The Great Giveaway continues...

Ever tried to get unique items out of the events table in SQL Notification Services?

Use the greatest EventBatchId with EventCount greater than 0 from the EventBatches table, to identify the latest set of events written to the Events table.

The Current Events table will have the events trapped by the events query at runtime, however the records are temporary and get dumped to the events table. The above method is the best way to locate the latest events.

Ciao for Niao