I have just inherited some databases at work that have no associated documentation, and am trying to tidy it up alittle as there are 1,000s of stored procedures, and a large proportion of are nolonger used (supersided by phase 2 of the implementing project).
Is there a way of mapping which Stored Procedures are called by DTS Packages.
Any help would be appriciated.
Using SQL Server 2000 Enterprise.