Find and replace text for all sprocs on a server

• Jake Shelton

  Hall of Fame

  Points: 3109

  More actions

  April 24, 2014 at 10:30 am

  #396654

  Hi all,

  There are plenty of scripts to do this on a per-DB level, but any that will allow me to generate a script for all DB's at once? Mine are split across dozens and it would be much easier to do a loop (using MS_ForeachDB ? )

  Cheers,

  Jake

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  April 24, 2014 at 10:36 am

  #1708502

  sp_msForEachDB would do.

  You could also check out my humble replacement[/url]

  -- Gianluca Sartori