Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    13

    Unanswered: Add Linked Server Failed

    hi,
    i have added a link server but it fails when i try to retrieve data.

    SQL server in on the same machine
    i have created the another SQL server instance

    Main Server: SERVER1
    Instance: SERVER1/NewServer

    EXEC sp_addlinkedserver @server = SERVER1/NewServer, @srvproduct = 'SQL Server'
    EXEC sp_addlinkedsrvlogin 'SERVER1/NewServer', false, NULL, 'sa', 'test'

    select * from SERVER1/NewServer.db1.dbo.tbl_Prouduct

    when i try to run the above query it gives me the error
    Server: Msg 170, Level 15, State 1, Line 1
    Line 1: Incorrect syntax near '/'.


    anyone have suggestion??
    Adi
    Last edited by adeelnasim; 11-25-04 at 06:04.

  2. #2
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up

    try this
    select * from [SERVER1/NewServer].db1.dbo.tbl_Prouduct
    Sudar

    --
    My Blog

  3. #3
    Join Date
    Sep 2004
    Posts
    13
    i try this too but its still not working

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •