Getting started
Published 09 June 2017
Analyzing a database
- Select a database in the object explorer
- Click Analyze database in the SQL Code Guard window
- After a few moments a list of detected issues is generated
- Double click on an issue or click on the eye icon to open the object and navigate to the issue
- Click on the question mark icon to invoke more detailed documentation on the error
Analyzing the script in a query window
- Open a query window
- Click Analyze query in the SQL Code Guard window
- After a few moments a list of detected issues is generated
- Double click on an issue or click on the eye icon to navigate to the position of the issue in the script
- Click on the question mark icon to invoke more detailed documentation on the error
Ignoring rules
You may want to exclude some rules from the check.
- Click the Rules botton on the right of the SQL Code Guard window
- A list of rules will appear
- Using the dropdown, change the value from Warning to Ignore
- Click OK to persist your changes
Note: These settings can be shared as a standard rule set for your team, or used as a command line switch to specify the rule selection for your automated static analysis scenarios. The rule selections are saved in %APPDATA%\SqlCodeGuard.Addin\settingsv3.xml.
