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
Author
Message
Posted Saturday, November 10, 2012 10:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 7:19 AM
Points: 161, Visits: 506
Hi,

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.

Thanks
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: Tuesday, August 19, 2014 1:58 PM
Points: 367, Visits: 615
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.

http://msdn.microsoft.com/en-us/library/ms178069.aspx
Post #1383889
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse