Post reply

Linked Server

  • December 8, 2005 at 4:22 pm

    #166806

    Hi,

    I am on SQL 2005. What do you go about getting information from information_schema on linked server?

    SELECT

    Column_Name from servername.databasename.information_schema.columns WHERE Table_Name = 'tablename'

    Thanks,

    Chris

  • December 11, 2005 at 9:00 am

    #608903

    You can get that information by using the distributed queries procedures like sp_linkedservers, sp_helplinkedsrvlogin etc.. Look up BOL for "System Stored Procedures" and in there look for "Distributed Queries Procedures"

  • December 13, 2005 at 4:34 pm

    #609345

    Thanks for the tip..

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

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