title: What is the best way to test a stored procedure?
body: <p>Like many companies that require all access be through stored procedures, we seem to have a lot of business logic locked away in sprocs.  These things are just plain hard to test, and some of them have become silly long.  Does anyone out there have a set of best practices that can make it a little easier to confidently test these things?</p>
  
  <p>At present we maintain 30 or so "Problem" databases that we run against.  This isn't always particularly well documented and it sure isn't automated.</p>