We need to “find & replace” an external Db name (SQl Server) in agents that reside across multiple Dbs in the domain. Is there a way to do a single search that looks for “SQLA” and replaces with “SQLB” across all agents in databases on server A? I tried selected all agents in a single Db and cannot choose find & replace. The only option is opening the agent and using find & replace. Needless to say, this would take serious time. Honestly, we are not certain if other Dbs contain the reference. Thanks team… “find & replace” at the Db level would be nice.
Subject: Find & Replace Text in Agents (Multiple Dbs)
That is the province of third-party tools, such as TeamStudio Configurator.
Subject: RE: Find & Replace Text in Agents (Multiple Dbs)
Configurator is worth its weight in platinum…
Don’t forget the nifty (free) script helper tool they just put out.
- Matt