How TFS forces the removal of a terminated person from checking out locked items

Project Team A Buddy walked out of the file in an exclusive way, and now no one else can modify it, and the administrator seems unable to remove the file. After groping, found a way of violence-directly to the TFS database . Although violence, it can really solve the problem.

Steps:

1, connected to the TFS database Server TfsVersionControl Library;

2, check the Tbl_workspace table, find out the buddy's working directory,

such as SELECT * from Tbl_workspace where workspacename= ' name '

3. Use the Workspaceid found in the previous step to find the item that has not been checked in the Tbl_pendingchange table,

Example: SELECT * from Tbl_pendingchange where workspaceid= ' 12 '

4, delete these items!

such as:--delete from Tbl_pendingchange where workspaceid=12

Problem Solving!

Note that after you delete the data from the Tbl_pendingchange table, you also check for data that is not locked in the Tbl_lock table.

If so, it should be deleted as well.

such as:--delete from Tbl_lock where workspaceid=12

TFS Force Removal of a method of checking out locked items by a departing person (go)