Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: Wednesday, March 26, 2014 7:19 AM
Points: 161, Visits: 506

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: Friday, April 17, 2015 3:48 PM
Points: 370, Visits: 633
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