RED GATE SOFTWARE SQL Test - Licence and Support - 1 User - 12 Months

If you want to do SQL Server unit testing in T-SQL, and run it as part of your automated builds, SQL Test is the place to start.
It's simple to set up, you don't need extra tools, and you don't need to learn new technologies.
SQL Test also comes with pre-written SQL Cop tests, to help you enforce best practices for database development and run static analysis tests.