Post reply

Passing of user defined tables between databases

  • November 10, 2012 at 10:56 am

    #284619

    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

  • November 12, 2012 at 3:05 pm

    #1558334

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply