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
A:
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:
Robaticus
2010-09-01 14:53:55
This is just what I needed. I found the entries with the old IdentityID and updated them to the new IdentityID and he was able to unshelve his old changes. Thanks!
Ryan
2010-09-01 18:50:32
Glad I could help. Thanks for getting me to learn a little more about the internals of TFS.
Robaticus
2010-09-01 18:55:26