selecting on table via linked server

• ap7320

  SSC Veteran

  Points: 264

  More actions

  January 15, 2003 at 7:09 am

  #75990

  I have created a linked server and am trying to query a table using the four-part name requirement (server.catalog.schema.table). I am getting a SQLSRV-07312 error. I'm guessing I am not setting my linked server up right. Can anyone help?

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  January 15, 2003 at 11:13 am

  #446399

  Try exec sp_serveroption 'Servername','Data Acess', True

  GO

  Select * from servername.dbname.ownername.tablename