Global Replace

• mikepage

  SSC Enthusiast

  Points: 123

  More actions

  June 11, 2003 at 8:17 pm

  #80358

  Hi All,

  Sorry for the newbie question, but . .

  I have just moved about 100 stored procs to a different server. I now need to update the databases referenced by them. Is there a quick way to do a global replace across all the sp's in a database?

  Thanks

  Mike

• mworku

  Ten Centuries

  Points: 1311

  More actions

  June 11, 2003 at 9:33 pm

  #460944

  You can script all of them in one file and just do search and replace

  MW

  
  MW

• mikepage

  SSC Enthusiast

  Points: 123

  More actions

  June 11, 2003 at 9:56 pm

  #460945

  Of course!! <light comes on>

  Thanks

• mworku

  Ten Centuries

  Points: 1311

  More actions

  June 12, 2003 at 6:44 pm

  #461188

  Unless you're an expert in Regex

  MW

  
  MW