Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Passing of user defined tables between databases Expand / Collapse
Posted Saturday, November 10, 2012 10:56 AM


Group: General Forum Members
Last Login: Friday, January 15, 2016 8:44 PM
Points: 161, Visits: 508

I've the same user defined data type in 2 databases. When I declare it in one database and pass to a stored procedure in another database, I get an error. Is there a clean way to do this? Don't want to use CLR at the moment.

Post #1383385
Posted Monday, November 12, 2012 3:05 PM

Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 3, 2016 3:17 PM
Points: 373, Visits: 644
Unfortunately, much of the user-defined objects within the databases are not sharable between databases. That is true even if the definitions are identical.

You can give this article a try and see if it works for you.
Post #1383889
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse