SharePoint Alert Queue

I was trying to find an easy way to see the alert queue in our SharePoint WSS 3.0 envrionment and I came across the SQL table called [SchedSubscriptions] and took a look at it and sure enough there were all the open alerts, including username, website and email, etc.

So all u need to do is delete all records in the table.

There is also another table called [ImmedSubscriptions] which shows you the current alert settings.


Ross G