This is a great question... if someone has an answer that would be awesome. We had the same requirement and ended up putting a global variable test at the top of each stored procedure such that when it was set the procedure simply returned true and did nothing else.

Not much of an answer I know but I wanted to keep an eye on this thread :-)