variable for a linked server name

• mtz676

  SSCrazy Eights

  Points: 9249

  More actions

  October 16, 2024 at 10:03 am

  #4469084

  How do I use a variable name for a linked server name in a linked server query?

  set @servername = (SELECT TOP (1) [ServerName]

  FROM [Database].[dbo].[Servers]

  declare @servername =

  SELECT * FROM [SERVER_NAME].[DATABASE_NAME].[SCHEMA_NAME].[TABLE_NAME]

  SELECT * FROM [@servername ].[DATABASE_NAME].[SCHEMA_NAME].[TABLE_NAME]

   

  Ideally how can I backup all servers/databases onto a single fileshare from a single server as a sqljob ?One server will be chosen from this query SELECT TOP (1) [ServerName]

  FROM [Database].[dbo].[Servers] every time the sqljob runs.

  • This topic was modified 5 months, 3 weeks ago by  mtz676.
  • This topic was modified 5 months, 3 weeks ago by  mtz676.

• Phil Parkin

  SSC Guru

  Points: 247125

  More actions

  October 16, 2024 at 12:12 pm

  #4469145

  Dynamic SQL is one way of creating a variable SELECT statement that can be executed.

  • This reply was modified 5 months, 3 weeks ago by  Phil Parkin.

  ---