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.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  TempDB in SQL Server 2005

Author  Topic  DMP Starting Member 41 Posts Posted - 2007-01-03 : 08:31:27 Hi, I am facing a misc problem in SQL 2005, In SQL 2000 I am creating #Temp table with an user define data type from DMP User Account whose role is non db_owner and it was working fine. But when the database shift to SQL Server 2005 it is giving following error. Whenever DMP user will be db_owner it was working fine. But why ? Sample Code : User Define Data Type: utNAV Numeric(24,12) Create Table #Temp (Book utNAV) Server: Msg 15247, Level 16, State 4, Line 1 User does not have permission to perform this action. Regards,