Deleting Data from Different DB on different servers

• Mark Simmons

  SSC Enthusiast

  Points: 102

  More actions

  July 13, 2006 at 2:33 pm

  #67565

  I current have a job setup to run on my SQL 2000 box, this job deletes information from various tables.  My question is this, using the same job can I have it also delete information from other DB’s that reside on other servers. I would like to have only one job instead of having to create one on each of the additional servers. The tables would all be the same on the other servers...Thanks in advance

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  July 14, 2006 at 12:14 am

  #649145

  you can use link serves.

  using link servers you can link the SQL Server

  then delete from [LinkServerName].[dbo].[DBNAme].[TableName]

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Norene Malaney

  SSCommitted

  Points: 1896

  More actions

  July 14, 2006 at 7:05 am

  #649230

  As Dinesh mentioned, you can use "linked servers".  To setup a linked server through EM, do the following

  1) In EM, open up the "Security" folder on the database server you want to create the linked server on

  2) Right-mouse click on "Linked Servers" and choose "New Linked Server". 

  3) Specify the connection properties for the linked server in the window that appears.

   

  ---

  Have a good day,

  Norene Malaney