Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Paul Ibison Script that talks to multiple DBs cant be put into a SP RE: Script that talks to multiple DBs cant be put into a SP

  • April 8, 2011 at 6:14 am

    #1309080

    for crossdatabase stuff inside a procedure , you only got two choices;

    1: can you adapt the specific script to use 3 part names?

    you know, SELECT * FROM Production.dbo.Invoices

    or

    2: switch to dynamic SQL and EXEC a string: multiple commands are simply semi-colon delimited.

    DECLARE @isql VARCHAR(1000)

    SET @isql = 'USE SandBox; SELECT * FROM dbo.Invoices; SELECT @@version;'

    EXEC(@isql)

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!