Hi Everyone, i am working on Sharepoint 2003 , i need to delete user alerts who left the company is there any way to delete the alerts in the backend using sql , please let me know. Regards,

Moving to Admin because you should never amend the database by using SQL. MS strongly recommend against it. You risk a corrupt database and Microsoft will no longer support you. FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com Complete Book Lists (incl. foreign language) on each site.

Hi, Mike is correct. All modifications to the SharePoint database are unsupported by Microsoft. Please try to use this tool to manage users who left the company in the SharePoint site. http://blogs.msdn.com/nigelbridport/archive/2004/12/16/317419.aspx Hope it can help.Lily Wu