I have a lot of interest in this topic. I'm glad you're taking TSQLUnit beyond the discussion I had in my article a couple of years ago (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro04/html/sp04i1.asp).

I followed you up to the point where you query sysobjects for a list of stored procedures and their parameters. After that things get murky for me. Seems that your statements that the individual programmer needs to determine expected results runs contrary to your efforts to generate templates.

You also have a note about running a comparison set between two data sets. I'm not quite understanding here. (It might be just me that's a bit slower than normal. I've traveled about 15,000 miles in the last couple of weeks.)