Best way to update procs - on many db's same server

• krypto69

  SSChampion

  Points: 13604

  More actions

  June 25, 2009 at 2:31 pm

  #155876

  I have to update about 20 procedures on over 50 databases. Going to take forever to do one at a time.

  All the DB's have the same schema, and it's really just a simple alter statement I'm running.

  Is there a script or easy way to do this? A little utility perhaps.

  I can't use RedHat SQL compare (my usual) due to network constraints.

• ab5sr

  SSCarpal Tunnel

  Points: 4056

  More actions

  June 25, 2009 at 2:33 pm

  #1015606

  Wonder if you could use sqlcmd for this?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  June 25, 2009 at 3:01 pm

  #1015637

  You could loop through the databases using sp_msforeachdb. Check out this article for how to use it.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question