http://blogs.msdn.com/b/robcaron/archive/2006/07/17/668047.aspxI don't know how popular the blogs from the Team Edition for Database Pros team have grown, so I wanted to draw some attention to Sachin Rekhi's recent posts on database unit testing. What is database unit testing? Creating your first database unit testen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/robcaron/archive/2006/07/17/668047.aspx#670738Wed, 19 Jul 2006 10:58:55 GMT91d46819-8472-40ad-a661-2c78acb4018c:670738Operatoru' Bstrd din IadDespre database unit testing, aiciIn general despre Team SystemTeam System Dev Center, hostat tot pe...<img src="http://blogs.msdn.com/aggbug.aspx?PostID=670738" width="1" height="1">http://blogs.msdn.com/b/robcaron/archive/2006/07/17/668047.aspx#668759Mon, 17 Jul 2006 23:17:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:668759DylanIMO, the DB Unit Tests don't seem so valuable to me yet. &nbsp;I would love to be able to write tests against my stored procedures at the SQL level. &nbsp;But the things I want to test are that my GetTop10Products stored procedure actually returns the top 10 products based on the sample data I setup. &nbsp;I don't want to test that it returns a non-empty recordset, or that it returns a recordset with a rowcount of 10. &nbsp;I need to know if the actual data returned is correct (eg. that it returns products 13, 81, 91, 43...29, etc) <br> <br>Until we get to the point where tests such as that are easy, I don't think we will be realizing the true value of database unit tests.<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=668759" width="1" height="1">http://blogs.msdn.com/b/robcaron/archive/2006/07/17/668047.aspx#668078Mon, 17 Jul 2006 12:13:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:668078OAGreat~~~thanks<div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=668078" width="1" height="1">