Passing of user defined tables between databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Passing of user defined tables between...

Passing of user defined tables between databases

Rate Topic

Display Mode

Topic Options

Author

Message

Lexa

Posted Saturday, November 10, 2012 10:56 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 06, 2013 7:48 AM
Points: 152, Visits: 464

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

jerry-621596

Posted Monday, November 12, 2012 3:05 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 4:18 PM
Points: 363, Visits: 574

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 »

Permissions