changing servers

• Steven F

  Newbie

  Points: 9

  More actions

  September 30, 2004 at 4:00 pm

  #163421

  I'm trying to copy stuff from 1 server to another, but I dont want to hardcode the server string.  I'd like to do what I have below, but it wont work. Any ideas?

  DECLARE @server as varchar(100)

  SET @server = 'stageServer1'

  SELECT * FROM @server + '.database.tablename'

   

  Steven

• Phil Parkin

  SSC Guru

  Points: 246964

  More actions

  September 30, 2004 at 6:59 pm

  #524962

  Something like this should work:

  DECLARE @server as varchar(100), @sqltext as varchar(100)

  SET @server = 'stageServer1'

  set @sqltext = 'select top 10 * from ' + @server + '.[databasename].[owner].[tablename]'

  exec(@sqltext)

  Regards

  Phil

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin