We're having some issue with our migration. Some of the alerts were not suspended prior to migrating our systems which cause our outbound email alert queue to become quite large (currently around 220000 messages queued).
We suspended the alerts but were hoping to clear the queue prior to resuming and enabling SMTP on the new server.

Selecting all messages from the console and deleting them results in a "base.SendMessagesOneWay failed." error message, presumably due to the unusually large size of the queue.
We were hoping to be able to clear it directly on the SQL db but weren't sure where to look.

Any help would be appreciated it.
Best Regards,
Sam

Legacy Forum Name: Manually clearing Outbound Email queue from SQL db,
Legacy Posted By Username: swagner