RE: Changing Text in Multiple Stored Procedures From a Stored Procedure

Valued Member

Points: 61

March 28, 2011 at 5:47 am

Thanks nick,

My problem with the solution here is that the DBA is changing the code without the advantage of Alter or drop/create procedure. Would SQL server then regenerate the query plan for these amended procedures.

I can't think of a situation where I would use the posters solution. It feels somewhat 'cowboy' and slap dash for my liking.