Execution warnings
Last modified: October 1, 2024
The Execution Warnings window gives you a possibility to choose whether you want to see warnings when executing DELETE, DROP, UPDATE, and TRUNCATE statements without the WHERE clause.
When showing the warnings window, the following information will be displayed:
- Statement type (DELETE, DROP, UPDATE, TRUNCATE).
- Object name that will be influenced by the command.
-
Row number in the executed script corresponding to the expression’s beginning.
- The “Do Not Show Again” checkbox that disables notifications for the executed statement type.
The Execution Warnings window looks the following way:
Warning providers are supported on different levels - they include separate query analysis and the DML analysis of procedure, function, and trigger bodies. Document category and its specific notification rules are used when the script is checked.
Settings for each statement type
To access the Execution Warnings settings, proceed with the following steps:
- On the Tools menu, click Options. The Options dialog box opens.
- Navigate to Environment>Documents>Execution Warnings.
- To enable warnings for each statement type, select a checkbox for the corresponding environment.
- Specify the maximum size for the script analysis.
The Execution Warnings settings window looks the following way:
Download dbForge Studio for SQL Server and try it absolutely free for 30 days!
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.