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 - 2000-11-08 : 11:32:34
|
Cynthia writes "Hello,
My question is how do you get the master database to use the user-defined data types when executing a system wide stored procedure that you created in master from another database?
I am using Windows2000. When I call a stored procedure in master and send a parameter that is of a user-defined data type, I get an error something like this :
Column or parameter #1: Cannot find data type dtID.
Parameter '@id' has an invalid data type.
The data type is defined in both the current and master database. This works in sql 7.
Any help is greatly appreciated.
Cynthia" |
|
|
|
|
|
sql 8 user-defined data types error