SQL Test includes a number of static analysis tests you can run to detect issues with your database. For a comprehensive set of over 100 advanced static code analysis rules for SQL, Redgate offers SQL Code Guard.

Adding the SQL Cop tests

To add the tests, when you add a new database to SQL Test, make sure the Add SQL Cop static analysis tests check box is selected:

To add the tests to a database you've already added to SQL Test, in the SQL Test tab right-click the database and click Add SQL Cop Static Analysis Tests:

List of tests

The following static analysis tests are included:

• Ad hoc distributed queries 
• Agent service
• Auto close
• Auto create statistics
• Auto Shrink
• Auto update statistics
• Buffer cache hit ratio
• Column collation does not match database default
• Column data types (Numeric vs. Int)
• Column name problems
• Columns of data type text/nText
• Columns with float data type
• Columns with image data type
• Compatibility level
• Database and Log files on the same disk
• Database collation
• Database mail
• Decimal size problem
• Forwarded records
• Fragmented Indexes
• Instant file Initialization
• Login language
• Max degree of parallelism
• Missing foreign key indexes
• Missing foreign keys
• Old backups
• Ole automation procedures
• Orphaned users
• Page life expectancy
• Procedures named SP_
• Procedures that call undocumented procedures
• Procedures using dynamic SQL without sp_executesql
• Procedures with @@Identity
• Procedures With SET ROWCOUNT
• Procedures without SET NOCOUNT ON
• Service account
• SMO and DMO
• Table name problems
• Tables that start with tbl
• Tables without a primary key
• Tables without any data
• UniqueIdentifier with NewId
• Unnamed constraints
• User aliases
• Varchar size problem
• Views with order by
• Wide table
• xp_cmdshell is enabled