Deleting Digests
Microsoft BizTalk Accelerator for RosettaNet (BTARN) stores digests for outgoing messages, so it can validate them against signal content. However, BTARN does not delete the digests after validation. Periodically, you may want to delete these digests to maintain system performance.
When and How to Delete Digests
Digests are stored in the MessageDigestHelper table of the BTARNDATA database. Periodically, you may want to delete these digests from the table by using a stored procedure that deletes only those digests that are older than a certain period. The MessageDigestHelper table contains a TimeCreated property that you can use for this purpose.
Create a stored procedure with the following SQL statement (as modified for your purposes), and run the stored procedure to delete old digests. This sample statement deletes all digests more than seven days old:
delete from MessageDigestHelper where datediff(day, TimeCreated, getutcdate()) > 7
Note
The stored procedure must include a call to getutcdate, not getdate, because all BTARNSQL Server databases use UTC (Universal Time Coordinate) time.