Forum Discussion
STEVENOCT1967
Feb 21, 2023Copper Contributor
user defined types in temp tables and tables
hi we are Moving form sybase to MS SLQ . I am testing a stored proc that updates a temp table . The temp table contains user defined types. create table #msg_address( temp_msg_addr...
olafhelper
Feb 21, 2023Bronze Contributor
The type does exist if I look in the user defined types .
STEVENOCT1967 , it may exists in your user database, but temp tables gets created in the system database TempDB and there it's don't.