LessThanDot Site Logo


A decade of helpful technical content

This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.


Welcome to the LessThanDot SQLCop website.


The purpose of SQL Cop is to highlight potential problems in your SQL Server database. SQL Cop detects many different issues, some of which may not be a problem for you, and therefore can be ignored. However, it is recommended that you investigate each item displayed by SQL Cop and carefully decide whether or not it should be corrected.

SQLCop screenshot



SQL Test Integration

SQLCop tests can now be run from within SQL Server Management Studio with add-in named SQL Test available from Red Gate Software. SQL Test allows you to run the SQLCop tests, but also allows you to write and run unit tests for your TSQL code.

SQL Cop Help

Every effort was made to make sure SQL Cop is defect free. If there are any problems installing or running the application, please reach out to us on twitter or by entering a github issue.

Additional information