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 |
|
snarayan
Starting Member
10 Posts |
 Posted - 2003-11-05 : 00:36:37
|
| HiHave created a custom type using sp_addtype in model db and them I am using this custom type in creation of temporary table.exec sp_addtype Currency, 'decimal(20,4)', 'NOT NULL'create table #fxchange( value Currency)The sql is complaining. Is custom type suppoted for temporary table?Thanks in advanceSanjay |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-11-05 : 01:09:23
|
| Temp tables are created in Tempdb, so you need to create the type in Tempdb as well as your main DB.You could create the type in Model, then it will be in tempdb everytime the server starts.Damian |
 |
|
|
|
|
|
Custom Type Temp Table