locked
Database table for Global Lists RRS feed

  • Question

  • We have a problem on our TFS 2012 (Update 3) server.  Every few days global list items are disappearing.

    We can't figure out who or what is causing this deletion.  It seems to be the similar items that are disappearing.  (Though not the same each time.)  Everyone that has permissions is sure they are not doing it on purpose.

    I am at a loss for how this can happen.  The only thing I can think of is to turn on Change Data Tracking for the table that holds the global lists (so I can see when and what is causing the deletions.)

    Hence this question.  Which table in the TFS database stores the Global Lists?


    • Edited by Vaccanoll Wednesday, July 16, 2014 5:48 PM
    Wednesday, July 16, 2014 5:17 PM

Answers

  • Hi Vaccanoll,  

    Thanks for your post.

    The Global List items in Collection database>>dbo.Constants table, you can tracking the values in String and DisplayPart Columns. But please note that: the table not only stored the global list items.

    And we suggest you upgrade your TFS to TFS 2012 Update 4.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Vaccanoll Thursday, July 17, 2014 2:39 AM
    Thursday, July 17, 2014 2:23 AM
    Moderator

All replies

  • Hi Vaccanoll,  

    Thanks for your post.

    The Global List items in Collection database>>dbo.Constants table, you can tracking the values in String and DisplayPart Columns. But please note that: the table not only stored the global list items.

    And we suggest you upgrade your TFS to TFS 2012 Update 4.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by Vaccanoll Thursday, July 17, 2014 2:39 AM
    Thursday, July 17, 2014 2:23 AM
    Moderator
  • Thank you for your response!

    Is this issue something that was fixed in Update 4?

    Thursday, July 17, 2014 2:39 AM
  • Hi Vaccanoll,  

    Thanks for your reply.

    Yes, some issues fixed in Update 4.  But for this global list items disappeared issue, you should find which reason caused it.

    We suggest you upgrade to TFS 2012 Update 4 as the latest product version will has the better performance and fixed known issues.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, July 18, 2014 2:19 AM
    Moderator