One of the things with the tsqlUnit code is that it uses inline error trapping not the try/catch functionality that was brought in from SQL Server 2005.

Today's project is to attack the major stored procs and make use of the Try/Catch syntax to better handle errors rather than the inline error techniques. This should improve the stability and general performance of the system.

I will then look at the .Net stored proc system for the structure comparisons.