Unit Testing Stored Procs

I have some pretty important stored procs t开发者_高级运维hat I want to setup automated tests for. I'm using VS2010, Sql Server 2008, MSTest, TeamCity, and PSake. Are there any great tools or frameworks out there that do this?

it's a little outdated, but http://blog.coryfoy.com/2007/07/test-driving-stored-procedures-in-sql-server-in-vs2008/ gave me a good starting point when i was doing this

I would check out Java and look into JUnit or TestNG. There are some really rich frameworks out there any they tie into TeamCity really great.

Just an option I realize you might be tied to VS2010.