Can't create SP w/ User defined data type + create temp. table.!!!??

[Jason Froebe]

Hi,

This forum (sybase.public.sqlserver.urgent_communications) is intended for
SYBASE to post Urgent Customer Notifications about various Sybase branded
products. This is not a discussion forum.

Please use one of the other newsgroups at
news://forums.sybase.com/sybase.public.sqlserver.*

Thanks

Jason

"Andy Cheung" <an...@ctimail.com> wrote in message
news:67H6QC6...@forums.sybase.com...
> Dear all,
>
> I'm using ASE 12 client to connect to a ASE 11 database server. I'm trying
> to create a stored procedure in it. This stored procedure is using some
> user-defined data types and it will create some temporary tables (w/ some
> columns having user-defined data types). When saving the stored proc, it
> said those user-defined data types can't be found and those temporary
tables
> cannot be created!!! I tried to create those user defined data types in
the
> user database, master database and sybsystemprocs database. But, still
> doesn't work. Does anyone having any ideas?? Or any suggestion?? Thanks in
> advance.
>
> Best Regards,
> Andy Cheung
>
>
>
>

[Andy Cheung]

[Rey_Wang]

You need to create those user defined types in model, then
reboot ASE server.

Or temporily, just create them in tempdb.

[Jason Froebe]

<Rey_Wang> wroteHi,

This forum (sybase.public.sqlserver.urgent_communications) is intended for
SYBASE to post Urgent Customer Notifications about various Sybase branded
products. This is not a discussion forum.

Please use one of the other newsgroups at
news://forums.sybase.com/sybase.public.sqlserver.*

Thanks

Jason
in message
news:5A77DE6BAD3A40B1005055BB85256938.005012C485256938@webforums...