tag:blogger.com,1999:blog-37804916.post6965159212359475495..comments2023-12-28T01:19:53.688-08:00Comments on Team Foundation Server: Bug in TFS 2008: "TF50605: There was an error looking up the SID for "Mac Nolandhttp://www.blogger.com/profile/07086101163818736928noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-37804916.post-85267137037003562762011-03-17T16:09:22.869-07:002011-03-17T16:09:22.869-07:00but... but... how do I run SQL against that table,...but... but... how do I run SQL against that table, and what database do I connect to, etc., etc.?<br /><br />I'm just a simple farm boy, Jim. I knows how to check me out some code, but I dunno what the name of a SQL interactive tool is or what the names of the databases are, etc.<br /><br />Help?Br.Billhttps://www.blogger.com/profile/06013160756190151500noreply@blogger.comtag:blogger.com,1999:blog-37804916.post-65046766501755956742009-06-19T00:03:48.992-07:002009-06-19T00:03:48.992-07:00Thanks for the idea.
I couldn't use tf worksp...Thanks for the idea.<br /><br />I couldn't use tf workspace /delete command because of this error<br /><br />Here is the SQL command.<br /><br />UPDATE [TfsVersionControl].[dbo].[tbl_Workspace]<br />SET [OwnerId] = 100 --200<br />where [WorkspaceId] = 1679<br />-- commit tran<br /><br />where 200 is the invalid SID and 100 is a valid SID. Valid SID can be found in the same table. After that tf delete command works.<br /><br />tf workspace /delete workspace;usernameUnknownhttps://www.blogger.com/profile/10021949257715758632noreply@blogger.comtag:blogger.com,1999:blog-37804916.post-6920460993170639342009-06-19T00:02:28.502-07:002009-06-19T00:02:28.502-07:00This comment has been removed by the author.Unknownhttps://www.blogger.com/profile/10021949257715758632noreply@blogger.comtag:blogger.com,1999:blog-37804916.post-67544289053624916952008-08-11T14:11:00.000-07:002008-08-11T14:11:00.000-07:00Thanks Andre!!!Thanks Andre!!!Mac Nolandhttps://www.blogger.com/profile/07086101163818736928noreply@blogger.comtag:blogger.com,1999:blog-37804916.post-14570567317454460682008-07-30T11:32:00.000-07:002008-07-30T11:32:00.000-07:00Yeah.. I got this bug and posted here: http://foru...Yeah.. I got this bug and posted here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2667685&SiteID=1Andre Diashttps://www.blogger.com/profile/06374042418695944896noreply@blogger.com