sql 2008 changing stored procedures
Posted on 2012-08-27
Hello we have copied a production databases over to our Crash & Burn environment for further testing, what I want do ois repoint stored procedures against each of the database, the command I was running is a as follows, this was run against all non-system databases
set @searchString = 'ProdServer'
select @text = (replace (@text,@searchString,'CrashBurn Server'))
I have also tried to run this command as well against non-system databases ie master, msdb.
insert into tblObjects(ObjectID, ObjectName,colid )
select C.id, object_name(C.id),c.colid
from syscomments as C
join sysobjects as O on O.id = C.id
and o.type = 'P'
where C.text like '%'+ 'CrashandBurnServer' +'%' -- Modify this statement to suit your needs.
select * from syscomments
where id = 1045578763
has anyone had these issues before, we need to have this down pat for our DR testing as well.
I would be grateful for some sound advice