Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

It hasn't happened to me in a long time but I wrote an update statement and forgot to write the where clause. It was recoverable but a little piece of me still died. Are there any existing add-ins to prompt a user when they intended to run a statement missing a where clause?

share|improve this question
add comment

1 Answer 1

I'm not aware of any add-ins that do that, but I've had that same feeling. I use the Custom Color option in SSMS to make all production servers have red banners, to force me to do an "Are you sure?" in my head before hitting F5.

The other thing to do is get used to BEGIN TRAN, UPDATE, look at row count, COMMIT. Just don't forget to commit or your phone will ring.

It's worked well so far (fingers crossed).

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.