-
Msg 2715 after upgrade to SQL2005
After upgrading to MSSQL 2005 we have stored procedures which get this error
Msg 2715, Level 16, State 7, Procedure prc_sel_accruals, Line 37
Column, parameter, or variable #15: Cannot find data type umoney.
The user data type is defined in the database. I tried recompiling the SP, which suucceeds but then fails on execution.
The SP works under SQL2000. Is there anything we need to do after the conversion?
-
Can you post the definition of alias data type.
-
actually I just found the issue. The SP was creating the table in tempdb, so i needed to define the user data type there too along with the user DB. I also added it to model so it will stay in tempdb after a reboot. thanks...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|