Posted by Alex Kuznetsov on 11/07/07 19:26

On Nov 7, 8:00 am, Yash <yas...@gmail.com> wrote:
> Hi,
>
> We are in the process of tuning the performance of our stored procs in
> SQL 2000 and are looking for a tool that would help us in comparing
> the result sets of an old SP and a modified SP. The tool should take
> as input the names of the 2 SPs, a set of parameter values and invoke
> them. Internally it should compare the result sets returned and log/
> display the difference in result sets if any.
> We do not want to compare response time, but want to compare result
> sets just to be sure that the modifications have not changed the
> functionality of the SP.
> The tool should also be able to compare result sets of SPs that give
> out multiple record sets.
>
> Please let us know which tool we can use.
>
> Thanks,
> Yash

we developed exactly that:

http://www.simple-talk.com/sql/t-sql-programming/close-those-loopholes---testing-stored-procedures--/

[Back to original message]