Post reply

is it possible to run a Stored procedure on one server to access a table on another server?

  • November 22, 2007 at 6:35 am

    #179400

    is it possible to run a Stored procedure on one server to access a table on another server on the same network?, if so how would you get round the username and password for the second server? would you include that info in the SP?

  • November 22, 2007 at 6:42 am

    #753393

    You need to create a linked server using sp_addlinkedserver procedure

    EXEC sp_addlinkedserver

    @server='TestServer',

    @srvproduct='',

    @provider='SQLNCLI',

    @datasrc='YourServer\InstanceName'

    Then, create linker server login

    EXEC sp_addlinkedsrvlogin 'TestServer', 'false', 'sa', 'sa', 'password'

    Thats it.

    Now query the server,

    select * from TestServer.master.dbo.sysobjects

    --Ramesh

  • November 22, 2007 at 6:43 am

    #753395

    Hi,

    look at linked servers in BOL.

    Paul

  • November 22, 2007 at 7:25 am

    #753406

    many thanks Ramesh and Paul

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

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