table structure of linked server table

• the.hank

  SSC-Addicted

  Points: 427

  More actions

  May 13, 2011 at 12:24 am

  #238204

  HI ..i m newbie in sql server . can anyone tell me how to query table structre of a linked server in sql 2005. I knw we can do it on local table by ALT + F1 but on linked server how is it possible?..Thanks in advance ....enjoy everyone.

• deepak.a

  SSCertifiable

  Points: 5330

  More actions

  May 13, 2011 at 12:33 am

  #1324097

  hi

  Try this

  EXECUTE ('<DbName>.SYS.sp_help ''<schema.TableName>''') AT <LinkedServer>

  Regards

  Deepak.A

• the.hank

  SSC-Addicted

  Points: 427

  More actions

  May 13, 2011 at 12:41 am

  #1324098

  thanks Deepak but i m getting a error on running ur query that

  "Server 'asitcpu738' is not configured for RPC."

  Can u help ? Thanks in advance.

• deepak.a

  SSCertifiable

  Points: 5330

  More actions

  May 13, 2011 at 12:51 am

  #1324099

  Please check the linked server properties

• Syed Jahanzaib Bin hassan

  SSChampion

  Points: 11410

  More actions

  May 13, 2011 at 4:54 am

  #1324188

  Check the properties of the Linked Server as mentioned by the Deepak and shown in the attachment

  Regards,
  Syed Jahanzaib Bin Hassan
  BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

  My Blog
  www.aureus-salah.com

• Syed Jahanzaib Bin hassan

  SSChampion

  Points: 11410

  More actions

  May 13, 2011 at 5:12 am

  #1324195

  If you have required only columns information then you can use this also

  SET FMTONLY ON

  GO

  Select * from [linkedServer].[databaseName].[schema].[tableName]

  Regards,
  Syed Jahanzaib Bin Hassan
  BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

  My Blog
  www.aureus-salah.com