Prowatch - TRUNCATE TABLES

[Leo]

This we delete the 3 tables in prowatch that can grow out of control.

Do a backup before doing this and then after and look at the size of the backups

Click on Database Manager
Click Query Analyzer
Type -
TRUNCATE TABLE EV_LOG
TRUNCATE TABLE UNACK_AL
TRUNCATE TABLE AUDIT_LOG
EXECUTE

This will delete the 3 log files, MSDE is only good to 2gig total