SqlCop is a framework for enforcing and validating rules for Microsoft SQL Server TSQL. Here is one of the typical use cases. You have a lots of TSQL and you want to:
a) enforce code standards b) prevent certain TSQL from being deployed c) being able to add and manage custom rules easily d) have this avaailable from variety of clients with no dependency e) manage rules in one place