Ubitsoft SQL Enlight - Performing T-SQL Script Analysis

Using the Analyze Script command you can run static analysis over your T-SQL script.

Analyze a selection of T-SQL code

1. Edit the rules in the Analysis Rules using the Options command of the SQL Enlight menu.

Analyze T-SQL Script Example 1 -

2. Select SQL code or else the whole document will be analyzed.

3. On the SQL Enlight menu click Analyze Script button or use the Ctrl + Alt + A keyboard shortcut.

Analyze T-SQL Script Example 2

If there are T-SQL script analysis rules violations, the SQL Enlight Error List Window will be displayed and the violations will be marked in the text editor.

SQL Enlight Error List Window Example 3

Double-click any error message entry to open the file where the problem occurs, and move to the error location.

To sort the list, click any column header.

Use the Errors, Warnings, and Messages buttons to select which entries to display.

Errors

Indicates the number of Errors in the list. Click to toggle whether Errors are displayed.

Warnings

Indicates the number of Warnings in the list. Click to toggle whether Warnings are displayed.

Messages

Indicates the number of Messages in the list. Click to toggle whether Messages are displayed.