Shane,

If SpamFilter was moved to a different server it is possible that some emails will remain in the quarantine database. This is because SpamFilter supports multiple SpamFilter servers connecting to the same database. To do this, each server keeps track of the emails it quarantined. If you move SpamFilter to a new server, the old entries will be orphaned.

You can issue SQL commands to manually delete older emails. First mark old emails for deletion with the following:

UPDATE    tblQuarantine
SET         &nb sp;    Expire = 1
WHERE     (MsgDate < '2/1/2006')

The date syntax will depend on your DB platform. For Microsoft SQL for example it's:

UPDATE    tblQuarantine
SET         &nb sp;    Expire = 1
WHERE     (MsgDate < CONVERT(DATETIME, '2001-01-01 00:00:00', 102))


Once the older emails have been tagged for deletion, issue the following command to delete them:

DELETE tblMsgs
FROM         tblMsgs INNER JOIN
                        tblQuarantine ON tblMsgs.MsgID = tblQuarantine.MsgID
WHERE     tblQuarantine.Expire <> 0