Something to share with you – ever wanted to clear out the tracking database? two
ways to do this:
1. considerate way – only purges completed items
MSDN
BTS06 Proper Purge
2. inconsiderate way – FAST! purges ALL data in the DTA.
Stored Proc – dtasp_CleanHMData (useful in test environments etc)
This will truncate the tables within the DTA DB – just like new!
Cheers,
Mick.