Sunday, February 12, 2012

Alternative to using USE in a PROCEDURE

is there a way to get around not using USE in a PROCEDURE?

I need to because I have a main site that inserts information into other DB's that i use for various subdomains. But without being able to use USE i cant select which database is needed.

thx in advanceshould i use the master database and prefix my procedures with sp_?|||Huh second time in 2 mins. Use the fully qualified path to the entity

<database>.<owner>.<entity>

No comments:

Post a Comment