Colin

Perhaps the reason you haven't found anyone else doing it is becuase there are better ways.  Someone has already mentioned not calling from inside SQL, and this may or may...

Amen!  I'll take your .04 and raise you .02!

Though I feel a static function may be a little excessive for one inline if or conditional op' statement, (less stack use and...

Firstly a disclaimer, I haven't used this, so what I'm saying now is based on my interpretation of the documentation.

The sp_OACreate, Destroy etc. ...

I have to admit I've never used raiseerror, but I would assume it uses the default locale for your instance of SQL, or for the user that is executing the...

Next time you're accused of cluttering up, try a quick comparison.

Physical storage required to hold one SP and an execution plan vs storage required to hold a few thousand lines...

Just be sure that there are no other operations that are going to be requiring that constraint running whilst it is dropped.

Tony

Agreed, prevention is always better than cure.

Of course the several error handlers around your code and the friendly error reporting that you had time to write when you weren't putting...

As a developer and a DBA (I think a lot of developers are a bit of both nowadays) I make use of both techniques.  As others here have said there...