title: Limiting the number of updated/deleted rows in SQL Server Management Studio
body: <p>It is very easy to make mistakes when it comes to <code>UPDATE</code> and <code>DELETE</code> statements in SQL Server Management Studio. You can easily delete way more than you want if you had a mistake in the <code>WHERE</code> condition or, even worse, delete the whole table if you mistakenly write an expression that evaluates to TRUE all the time. </p>
  
  <p>Is there anyway to disallow queries that affects a large number of rows from within SQL Server Management Studio? I know there is a feature like that in MySQL Workbench, but I couldn't find any in SQL Server Management Studio.</p>