CODEWITHSUNDEEP
tfsshelveset
Ryan
Ryan

Reputation: 4662

How are shelvesets stored in the TfsVersionControl database?

I need to get access to a shelveset that TFS and TF Sidekicks can't access and I'm trying to figure out how the data is stored in the database so I can change the shelveset owner.

Upvotes: 4

Views: 2361

Answers (1)

Robaticus
Robaticus

Reputation: 23157

Ok, I found some information for you. Shelvesets are stored as workspaces in tbl_Workspace with the type = 1.

The following SQL will show you all of your shelvesets:

use TfsVersionControl;
select  * from tbl_workspace where type = 1

Once you find the shelveset, you may want to try the TFS Power Tools to do the unshelve.

Power tools link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=fbd14eea-781f-45a1-8c46-9f6ba2f68bf0&DisplayLang=en

Upvotes: 3

Related Questions