Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DMP
Starting Member
41 Posts |
 Posted - 2006-09-27 : 09:37:41
|
| Hi,Whenever I create a #Table with a user define datatype( Let utPHONENO), Sql Server given a message cannot find user define datatype utPHONENO though I define UDT on my working database.When I define UDT(utPHONENO) on TempDB it was working fine.But Problem is , When my server is download the UDT (utPHONENO) was autometically drop. Everytime UDT need to be create after Server upload.How to overcome the problem ?Thanks & Regards, |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-27 : 09:41:20
|
| If you are creating UDT in tempdb database, it will be lost after server restart..you will have to recreate it again.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
User Define Datatype on #Table