Hi,

What are the default event subscriptions that get registered with TFS installation? In other words, as soon as I'm done with a fresh install of TFS, what subscriptions should be available in TfsIntegration.dbo.tbl_subscription?

The reason why I am asking is because when we add a new Area in Team Explorer, it gets recorded in the TFSWarehouse.dbo.Area table, but is not available for selection for work items. Also, adding a new member to a TFS group does not make that person available in the work item dropdowns.

We had to make some modifications to the tbl_subscripton table to work around the issue of Active Directory lookup failing for a domain user upon firing an event, so I want to make sure that we have the proper TFS subscriptions in that table.

Thanks

I believe there are only two subscriptions in the table when it's installed, both for WIT (WIT subscribes to BuildCompletionEvent and DataChangedEvent -- see http://blogs.vertigosoftware.com/teamsystem/archive/2006/07/03/Subscribing_to_Team_Foundation_Server_Events.aspx for a screenshot).

Tbl_subscription doesn't control what shows up in the work item fields, such as Assigned To. That's controlled by the work item type definition. You can find the details on customizing work item types in the Visual Studio SDK (available at http://msdn.microsoft.com/vstudio/extend).

Buck

Hey Buck,

Thanks for that -- I looked at the screenshot and I was missing the DataChangedEvent subscription (must've been deleted by accident during the workaround creation that I mentioned previously), so now things are synch'ed up.

Much appreciated,

Vitaly