This may be due to the fact that there are more Recipients than Messages.
I.e. a message with multiple recipients is still only listed once, while the different recipients are listed separately.
Just stab in the dark, really...
Lapo
On Wednesday, November 12, 2003, at 11:33 AM, Christopher Elliott wrote:
We are using MSSQL7 for the Quarantine database. I notice that when I count the entries in both tables 'tblRecipients' and 'tblMsgCatalog', the numbers differ. Both counts are done from the same script. Is this correct?
select count(*) from tblrecipients ----------- 19417
(1 row(s) affected)
select count(*) from tblmsgcatalog ----------- 19361
(1 row(s) affected)
Regards
Chris Elliott
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 11/06/2003
** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
