Post reply

T-SQL

  • April 25, 2008 at 12:13 am

    #189423

    HI,

    I am trying to access data from a different srever by writing

    select * from [IPadress].database_name.dbo.table_name

    The following error is coming.

    Server: Msg 7202, Level 11, State 2, Line 1

    Could not find server 'IPaddress' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

    Can u please help me out in this regard.

    Thanks

  • April 25, 2008 at 12:22 am

    #806981

    You need to add a linked server before you can use 4-part naming to refer to a remote machine.

    If you're sysadmin, you shoul be able to do that yourself. Go to obejct explorer in management studio, Server Object -> Linked Servers

    If you're not sysadmin, you'll have to ask one of the admins to add it for you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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