...I LOVE the bass flute!:D

e

classically trained musician with a master's degree (rather dusty); piano, oboe, percussion...conductor, composer... i could go on. lol

...unless you listen to industrial techno? ...It's all hard dirty electronic...

An alternative I recently discovered is to use sp_refreshsqlmodule, which updates the dependency and other metadata for a procedure, function, or view. The following generates EXEC statements:

SELECT

'EXEC sp_refreshsqlmodule...