Need to search and replace text in all stored procedures in sql 2005 db

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
oldowner.stored_procedure_1
to
dbo.stored_procedure_1
etc.

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
to
SELECT Names from DBO.Dogs

Is there a simple way to do this?

Thanks in advanceStart Free Trial