Friday, November 13, 2009

TFS 2008 Remove Alerts

Today I had the need to remove alerts for a user no longer on the project.  It is easy to edit build alerts/notifications using Team Explorer or the TFS Power Tools.  But, I could not find a way to remove Work Item alerts for a user.  Maybe I was missing something simple, but I like to think I wasn’t.  Plus, with the user being a contractor, the email address that was used was not in exchange or tied to the domain account.  After some digging around, I found where TFS stores alert subscriptions in the database and simply deleted the rows.  I found them at

TfsIntegration.dbo.tbl_subscription

So far, this appears to work.  I anyone has a better/cleaner way, I would love to hear about it.

1 Comments:

Blogger Michael Freidgeim said...

Thanks, I've used SQL:
Delete [TfsIntegration].[dbo].[tbl_subscription]
WHERE [address] like 'UseremailAddress'

November 26, 2009 at 3:48 PM  

Post a Comment

Subscribe to Post Comments [Atom]

<< Home