Need to search and replace text in all stored procedures in sql 2005 db
Posted on 2008-02-11
I am moving my sql database from one server to another at a different hosting company.
In order to connect, I had to change the owner of the tables, functions and stored procedures from
The problem is there are many references in stores procedures to tables with the oldowner name.
So, I want to do a search and replace.
for example, to change
SELECT Names from OldOwner.Dogs
SELECT Names from DBO.Dogs
Is there a simple way to do this?
Thanks in advance