I'm currently rewriting some fairly old and complex stored procedures originally written in SQL2000 that I believe can be simplified using SQL2005 constructs. I want to be sure that I do not miss any subtleties in the original procedures and inadvertantly change the behaviour of them when particular parameters are passed. (e.g by dismissing some part as redundant only to find out later that it wasn't!) It occurred to me that I could log all calls to the stored procedures for, say, a week or so and then run these stored procedure parameters against both old and new versions and verify that there are no discrepancies. (or just auto generate a wide selection of parameter values myself and run the same test) Does anyone know of any software that will assist in this? Edit: I've tried save as text and then comparing with winmerge but it still takes a bit of manual faffing around with the files to get them comparable so the only differences are differences in results rather than differences in number of dashes it appends to the file for column headers etc.