Linki to other server using sp_addlinkedserver RRS feed

  • Question

  • Dear All,

                   i'm new to linked server... i just got some sample and tryed this.. but i get below error message, all the credital information are correct..

    EXEC sp_addlinkedserver
       @server = 'sampledb951',
       @srvproduct = '',
       @provider = 'SQLNCLI',
       @provstr = 'DRIVER={SQL Server};SERVER=;UID=sa;PWD=admin123;',
       @catalog = 'sampledb'

    the above executes fine... but error comes when i execute the below line

    SELECT * FROM sampledb951...fo_rsrvtn_hdr

    fo_rsrvtn_hdr is the table inside sampledb database...

    can any one say where a'm i going wrong

    Narayanan Dayalan - Zeetaa Business Solutions
    Wednesday, October 28, 2009 8:26 AM


All replies