migrate stored procedures
Posted on 2011-03-22
I have 625 stored procedure scripts which I need to migrate to a new testing database.
I have generated the scripts as files....however each script includes the "USE" statement with the name of the production database. For example:
select * from dbo.tb1
I need to either:
Generate these scripts without the USE
Ignore the USE when the scripts are executed so that I can I load them into the new testing database.
Is this possible?