TFS 2010: Delete alerts for all users

Run the following query against the collection db: use Tfs_DefaultCollection –Select * from tbl_EventSubscription Select ‘bissubscribe /unsubscribe /id ‘ + CAST(id as varchar(255))+ ‘ /collection http://TFS2:8080/tfs/ProjectCollectionName’from dbo.tbl_EventSubscriptionwhere ID>1   Copy the o/p of the above sql , open notepad, paste & save the file as a batch file.   Open elevated command prompt & change…

0