How to run same script in multiple databases at one shot

• alpoor reddy

  Mr or Mrs. 500

  Points: 515

  More actions

  February 8, 2007 at 3:36 pm

  #122884

  I wrote a generic script which needs to be executed on multiple databases ( around 30). How to execute this script so that it will run in all databases by just submitting once instead of logging on to each database excuting everytime

  I appreciate your help

   

• Sql Junkie-204042

  Hall of Fame

  Points: 3874

  More actions

  February 8, 2007 at 3:52 pm

  #688693

  Check out sp_MSforeachdb

  EXEC master.dbo.sp_MSforeachdb 'use [?] select db_name() '

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  February 8, 2007 at 5:29 pm

  #688711

  You can also use something like this:http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp

  ms_foreachdb works well with one server. When you move to multiple servers, it's a little more complex.