Administering datafile

• sb5473

  SSC Enthusiast

  Points: 127

  More actions

  June 10, 2008 at 7:04 am

  #208273

  I didn't specify the real server name instead of generic 'server1' in the sql. Now it works!

  Now I woul like to gather informations from all my ssql servers, and put them into the same table on a separate server which I use for tests. I have created linked servers, but what is the correct syntax to use to refer to their objects? e.g. select * from linkedServer1.master.systables?

  Please, how can I add a new question in my previous Topic, instead of creating another one?

  Thanks for your replies.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  June 10, 2008 at 7:31 am

  #826633

  You can reply to a previous thread or topic and post an answer that way (or a new question).

  The linked server syntax is four part naming, so server.database.schema.table.