SQLTeam.com | Weblogs | Forums

Tools display warning message before update all rows in sql server 2012


#1

hello
i need tools display warning message before update all rows in sql server 2012


#2

You could add a DML trigger to the tables to check for this condition, but it will add performance overhead to every write.

SSMSToolsPack can warn you if you are about to run an update or a delete without a where clause. I've used that tool in the past, and it has saved me from messing up production data.