Purging / deleting ExternalMailQueue which has around 700,000 records

• skb 44459

  SSCarpal Tunnel

  Points: 4768

  More actions

  August 4, 2022 at 5:58 pm

  #4072588

  What is the easy way to purge ExternalMailQueue ?

  I tried using END Conversation command but it takes lot of time.

  I dont want to retain any history. What is the quick and dirty way to clear all mail items including Queue.

   

• ScottPletcher

  SSC Guru

  Points: 100942

  More actions

  August 4, 2022 at 6:30 pm

  #4072594

  Maybe try:

  EXEC msdb.dbo.sysmail_delete_mailitems_sp

   

  SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

• August 17, 2022 at 9:06 am

  This was removed by the editor as SPAM

• September 1, 2022 at 5:36 am

  This was removed by the editor as SPAM