How are shelvesets stored in the TfsVersionControl database?

2.3k Views Asked by At

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.

1

There are 1 best solutions below

2
On BEST ANSWER

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