We have a SQL SERVER 2000 DB. We have up on 300 Stored Procedures. The issue we have is code coverage within the SP's. We have a number of stored procedures that do validation. Not unless we pump in various data and debug each SP we can not be confident that each line of each Stored procedure has been run.
Is there a code coverage tool or code profiler available for SQL SERVER and the stored procedures??