Ahh, now we are in a different scenario. What or who would stop you adopting best practice?

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...

Sorry, but I am not happy with this solution at all.

My view is that any changes to procedures must be auditable. therefore, first off I would have identified the procedures...