title: Unit Testing TSQL
body: <p>Is there anybody out there writing unit tests for their TSQL stored procedures, triggers, functions ... etc.</p>
  
  <p>I've recently started making database and restores and installs part of our automated Cruise Control build process.  Now I'm thinking about taking it to the next level where we do the install, then run through a list of stored procedure tests etc.</p>
  
  <p>I was going to just roll my own using MsBuild Extensions to invoke the tests.  However I'm aware of <a href="http://www.tsqltest.org/" rel="noreferrer">http://www.tsqltest.org/</a> and <a href="http://tsqlunit.sourceforge.net/" rel="noreferrer">http://tsqlunit.sourceforge.net/</a>.  I'm also aware that TFS has sql testing.  </p>
  
  <p>I just wanted to see what people in the real world are doing and if they have any suggestions.</p>
  
  <p>Thanks</p>