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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-21 : 20:54:27
|
Kalle Dahlberg writes "Hi!
I have got a problem after copying a database to a new server using backup/restore. When running stored procedures which use user defined datatypes, I get the error message: "Msg 2715,level 16, State 1 Column or parameter #1: Can't find type ". However, when I look in the systypes table, the type is there.
I thought of dropping and recreating the types, but that doesn't work because they are in use by the SP's. The SP's are encrypted by a vendor, so I cannot recreate them myself.
Have you got any ideas or suggestions why this is and how to resolve it?
Regards,
Kalle Dahlberg" |
|
|
|
|
|
Problem with user defined data types after copying to another server