Setting alerts in MOSS 2007 is very easy just go to any list or library right click on Actions Tab and the last option available is the Alert Me feature. Configuring these alerts is very simple and is a child’s play but customizing the alert emails which are sent and sending list specific email alerts and stuffs like this are little bit tricky. Don’t worry here we are not discussing those horrifying issues but here we are simply going to discuss on how to delete the alerts which user has set on a particular list. There is a very simple process to do this you don’t need to write code for that but i am sharing this with you as for the novice programmer it’s a tedious task to find actually where to go to delete these alerts. 
- Just go to “Site Actions” on the top right corner of your sharepoint site and then click “Site Settings”.
- Now look for the Site Administration section under that look for the User Alerts.
- Once the User Alerts page is opened select a user for which you want to delete the alert, as you select the username from the dropdown list then all the alerts related to that user will be displayed.
- Now you can select single or multiple alerts and click on the “Delete Selected Alert” link to delete the selected alert.
Stay tuned for more articles on Sharepoint (MOSS 2007) Happy Programming!!!!!!!!!!!!!!!!!!!