Classification: UNCLASSIFIED
Caveats: NONE
Well, I took a stab at it and it seems to have worked. I told my guys to do
a thorough exam before they got too crazy. (my backup and the SA snapshot
from VMWare only bring back changes prior to. We don't like to reapply days
and days if not needed).
I thought I would share this with all of you in case you ever needed to do
the same...
------------------------------------------------------------
select targetserveritem, i.displayname, p.workspaceid
from tbl_pendingchange p
inner join tbl_workspace w
on p.workspaceid = w.workspaceid
inner join tbl_identity i
on w.ownerid = i.IdentityID
where w.[type]=0
and i.displayname = 'DomainUserName'
--Tbl_PendingChange
delete from tbl_pendingchange
where workspaceID in (select p.workspaceid
from tbl_pendingchange p
inner join tbl_workspace w
on p.workspaceid = w.workspaceid
inner join tbl_identity i
on w.ownerid = i.IdentityID
where w.[type]=0
and i.displayname = 'DomainUserName')
--Tbl_WorkSpace
delete from tbl_workspace
where ownerID = IDFromQueryRanAbove
--Tbl_Identity
delete from tbl_identity
where identityid = IDFromQueryRanAbove
------------------------------------------------------------
Thanks,
-lance
A mistake does not become an error until one refuses to correct it.
-----Original Message-----
From: Bellizzi, Christopher Joseph [mailto:[Email address protected]
Sent: Friday, August 08, 2008 2:51 PM
To: Lantz, Jeremy V SFC NGIN
Subject: RE: Does anyone deal with Team Foundation Server databases?
(UNCLASSIFIED)
That sucks. I guess get a good backup before you wack.
PAYCHEX
Christopher Bellizzi
Information Technology * Database Administration
675 Basket Road * Webster, New York 14580
(585) 216-0670 * [Email address protected]
-----Original Message-----
From: Lantz, Jeremy V SFC NGIN [mailto:jeremy.v.[Email address protected]
Sent: Friday, August 08, 2008 2:44 PM
To: Bellizzi, Christopher Joseph; LazyDBA Discussion
Subject: RE: Does anyone deal with Team Foundation Server databases?
(UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
Let him know I appreciate the efforts.
Unfortunately, my guys showed me that it doesn't work for them. They have
that tool already and have tried to use it but to no avail.
The AD account was deleted and then recreated (we are dual status on this
domain) for his military duties. So, the username exists but the GUID does
not match. It seems that this is the issue and this is why the tool can't do
anything with it. It works great for other users that are still on the
domain (test subjects) but not in this case.
Thanks,
-lance
A mistake does not become an error until one refuses to correct it.
-----Original Message-----
From: Bellizzi Christopher Joseph [mailto:[Email address protected]
Sent: Friday, August 08, 2008 2:36 PM
To: Lantz, Jeremy V SFC NGIN
Subject: RE: Does anyone deal with Team Foundation Server databases?
(UNCLASSIFIED)
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed any
attachments, and kept your email address secret **from this person, and any
viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text
Got this from our TFS admin. He has quite a bit of experience with it.
Chris,
The admin of the TFS server can use the TFS Sidekicks power tool from
Attrice to accomplish this.
In this tool, you can find the user's workspace(s) and delete them.
This will undo all pending changes that were in the workspace.
FYI, it is not a good idea to toy with the tables in TFS databases...
only Microsoft knows for sure what they are doing.
Ron D.
PAYCHEX
Christopher Bellizzi
Information Technology * Database Administration
675 Basket Road * Webster, New York 14580
(585) 216-0670 * [Email address protected]
-----Original Message-----
From: Lantz Jeremy V SFC NGIN
[Email address protected]
Sent: Friday, August 08, 2008 1:43 PM
To: LazyDBA Discussion
Subject: Does anyone deal with Team Foundation Server databases?
(UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
My web team uses TFS and I have never messed with any of it before.
Anyway,
they at some point had a person leave the team on bad terms and his AD
account was deleted. Now they want to clean up TFS but they can't use
the
app because the bindings are there.
They would like me to hack it and drop out all of his workspaces and
"checked
out" links because it is no longer valid (he left a year ago) and they
have
all of the work (TFS is just messed up).
If anyone is familiar with it I would truly appreciate your guidance. I
have
checked out google and I am targeting what I believe to be the right
tables
but, just as a fail-safe I thought it best to ask.
Thanks,
-lance
A mistake does not become an error until one refuses to correct it.
Classification: UNCLASSIFIED
Caveats: NONE
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
The information contained in this message may be privileged, confidential,
and protected from disclosure. If the reader of this message is not the
intended recipient, or any employee or agent responsible for delivering this
message to the intended recipient, you are hereby notified that any
dissemination, distribution, or copying of this communication is strictly
prohibited. If you have received this communication in error, please notify
us immediately by replying to the message and deleting it from your computer.
Thank you. Paychex, Inc.
Classification: UNCLASSIFIED
Caveats: NONE
Classification: UNCLASSIFIED
Caveats: NONE
MS Sql Server LazyDBA home page