Post reply

table structure of linked server table

  • 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.

  • May 13, 2011 at 12:33 am

    #1324097

    hi

    Try this

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

    Regards

    Deepak.A

  • 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.

  • May 13, 2011 at 12:51 am

    #1324099

    Please check the linked server properties

  • 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

  • May 13, 2011 at 5:06 am

    This was removed by the editor as SPAM

  • 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

Viewing 7 posts - 1 through 6 (of 6 total)

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