Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

Your Answer


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.