Does anyone know of a tool that will search for a word and
replace it in views, triggers, and stored procs???
Here is my situation with pubs and northwind databases
used for an example:
There is a view, trigger, and stored proc in pubs that
references the database northwind by means of the code
I Backup pubs
I Restore pubs to a new database called pubs_B
The view, trigger, and stored proc now need to point to
northwind_b so the code needs to be
changed to northwind_b.dbo.table.column
Is there an easy way to do this for a whole bunch of code?
I can do it manually but it takes forever.