My article related to Prevent accidental update or delete commands of all rows in a SQL Server table is published on following address. Due to copy right restrictions i will not publish it here. You may visit it at Prevent accidental update or delete commands of all rows in a SQL Server table. It would provide efficient way to make sure that if you forget to include where clause in update or delete scripts then all rows should not be updated or deleted.
DBA best practices, DBA Interview questions, dbDigger, Publications of Atif Shehzad on MSSQLTips.com, Triggers