Home Forums SQL Server 7,2000 SQL Server Newbies Calling a stored procedure on data in a linked server RE: Calling a stored procedure on data in a linked server

  • March 21, 2005 at 5:39 pm

    #548103

    A stored procedure can query data in databases other than the database it exists in, via 3 part naming (DBName.DBOwner.TableName) or on linked servers via 4 part naming.

     

    CREATE PROCEDURE TestProc

    As

    BEGIN

       SELECT * FROM SomeOtherDB.dbo.YourTable

    END