Welcome to the world of TFS - sorry that your baptism is going to be one of fire.
You are correct to be wary of editing the database directly - always best avoided with TFS. The TFS Event Subscription tool (originally crafted by this sites creator) should be able to do the job, but I think that it may be a bit out of date and could do with some love. Last time I tried it wasn't working for me - but I think it might have been updated since then.
If that tool doesn't work for you then this is one instance where you can actually get away with using the web services directly (which is what that tool does under the hood).
CAVEAT - This is tested with the "Works on My Machine" guarantee. But if you remove the wrong subscription then you risk messing up your TFS instanllation. Therefore take backups and tread carefully...
To begin:
Log in to the TFS machine as the TFS Admin user (TFSSETUP) over remote desktop, and then browse to the following address in Internet Explorer:
http://localhost:8080/Services/V1.0/EventService.asmx
These are the Event Service web service methods. The first one you want to look at is the EventSubscriptions method:-
http://localhost:8080/Services/V1.0/EventService.asmx?op=EventSubscriptions
In the userid field, enter an asterisk (*) and then press invoke.
This will then return a big list of all the event subscriptions in TFS - including the ones that allow parts of TFS to talk to other parts. If you scroll down, you will find your email subscriptions. Make a note of the ID's of the ones that you want to delete.
Then go to the unsubscribe method:
http://localhost:8080/Services/V1.0/EventService.asmx?op=UnsubscribeEvent
Enter the ID of the notification that you wish to remove and press invoke. Repeat for all the events that you wish to remove.
Once you have removed the ones you don't want you can create different ones using the power tools etc.
Hope that helps - good luck.
Martin.
Note that do don't get any friendly undo prompts or anything as this is fairly low-level hackery. Therefore you want to have backups etc before you do this.
The missing green icons can be explained here. It is because Windows has a limit of overlay icons it supports. The details on how to fix it are in that blog post.
How long are you waiting after entering a folder before you perform the first Right Click? It sometimes takes a while for the TfsComProviderSvr.exe
to check if the local folder is a workspace and register the shell extension.
Best Answer
It seems Alerts Explorer is no longer available in Team Project menu.
To create an Alert, you can open Alerts Explorer in following ways:
From the Team menu in Visual Studio, click Alerts Explorer.
From the Team Explorer window, right-click the server\team project collection and then click Alerts Explorer.
For Work Items, you can Right Click a Work Item and choose 'Alert on change..'.