Cory Foy has written a great blog post about using Database Unit Testing in Visual Studio 2008 (a.k.a. Orcas), but don't be fooled you can do all of this today in Visual Studio Team Edition for Database Professionals v1.0.

Please check out his blog post, it is a great read.

http://www.cornetdesign.com/2007/07/test-driving-stored-procedures-in-sql.html

-GertD