how do you execute t-sql code for each instance on server automatically?

• JP10

  SSCarpal Tunnel

  Points: 4372

  More actions

  December 13, 2012 at 4:55 pm

  #286386

  HI,

  I have this code below and I have 4 instance of sql. How can I execute this code below for each instance without having to open 4 different mgt studio query connections for each instance to see the results? Appreciate the help.

  exec sp_MSforeachdb '

  use ?

  select * from table1 '

• SQL Show

  SSCertifiable

  Points: 6143

  More actions

  December 13, 2012 at 9:40 pm

  #1568547

  Try to use Central Management Server.

  http://msdn.microsoft.com/en-us/library/bb934126(v=sql.105).aspx

• jeetsingh.cs

  SSCommitted

  Points: 1761

  More actions

  December 13, 2012 at 10:59 pm

  #1568554

  Two ways to do this are

  1. to use exec MS_FOReachDB

  http://www.mssqltips.com/sqlservertip/1414/run-same-command-on-all-sql-server-databases-without-cursors/

  2. to use cetnral management server.

  http://msdn.microsoft.com/en-us/library/bb934126.aspx

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  December 14, 2012 at 3:34 am

  #1568622

  Or create yourself a Local Server Group in the Registered Servers tab in SSMS, this allows you to run multi-server queries in one window.

• JP10

  SSCarpal Tunnel

  Points: 4372

  More actions

  December 14, 2012 at 10:31 am

  #1568782

  awesome thank you everybody! soon as i posted this i found it online. central management servers did the trick! awesome stuff!