You could run the ddl-statement through a dynamic sql statement together with a 'USE otherdb' statement, or through a OPENQUERY link back to the same server. Why would you want to do this?
If you create an stored procedure begining with sp_ in the master, then you can use it from any database like all the stored procedures that come with SQL.
Although Microsoft doesn't recommended, if you know how to use it, i didn't find any problem.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply