T-SQL

• sunandas

  Old Hand

  Points: 357

  More actions

  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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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