locked
Set TFS 2010 Work Item ID Seed

    Question

  • Hello, I saw the following post about how to set the Work Item ID seed on TFS 2008 - how about TFS 2010?  Is it the WorkItemsAre table in Tfs_DefaultCollection DB?

     

    http://social.msdn.microsoft.com/Forums/en-CA/tfsprocess/thread/d84b451c-6963-4099-ad1a-11a9527a62b9

    Wednesday, June 02, 2010 7:42 PM

Answers

  • Hi Dan,

    Based on your description, it seems that you want to organize the work items ID as your requirement.

    You can try Bill's trick mentioned in the link that you posted. If it succeeds, please feel free to let me know.

    To be honest, it is not recommended to manually change the default work item ID since the ID field relates to several data tables in Database. If we change one, we need to change other tables. It would be risky for your important work.

    However, I think that you might try some trick to get it to work. We can customize one new ID field and manually assign the value to it. This field is controlled by ourselves. TFS will not automatically change it.

    Firstly, what we need to do is to download and install Team Foundation Server Power Tools. We need the feature "Process Editor" inside to do the work.

    After we launch Team Explorer, please go to Tools menu >> Process Editor >> Work Item Types >> Open WIT from Server. We will get Work Item Type Editor.

    In Field tab, click "New" to create a new field. You can enter the information of this new ID field.
    (Note: For "RefName", you can enter any name you want.)

    Then go to Layout tab, add this field onto the work item dialog box.

    Then refresh Team Explorer.

    When you create a new Work Item, you will get "Item ID" field in the Work Item dialog box.
    When you save the work item, the "Item ID" data will be saved into the database on your server.

    Hope this helps! If you have any concern, please feel free to let me know.

    Best regards,
    Yichun Chen
    MSDN Subscriber Support in Forum
    If you have any feedback on our support, please contact msdnmg@microsoft.com
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Edited by YiChun Chen Thursday, June 03, 2010 10:22 AM typo
    • Marked as answer by YiChun Chen Wednesday, June 09, 2010 10:00 AM
    Thursday, June 03, 2010 10:20 AM

All replies

  • well, I tried that table and it seemed to work... this is how I changed it to 5001...

    DBCC CHECKIDENT('WorkItemsAre', RESEED, 5001)

    I'll post again if I see any issues...

    dan

     

    Wednesday, June 02, 2010 8:05 PM
  • Hi Dan,

    Based on your description, it seems that you want to organize the work items ID as your requirement.

    You can try Bill's trick mentioned in the link that you posted. If it succeeds, please feel free to let me know.

    To be honest, it is not recommended to manually change the default work item ID since the ID field relates to several data tables in Database. If we change one, we need to change other tables. It would be risky for your important work.

    However, I think that you might try some trick to get it to work. We can customize one new ID field and manually assign the value to it. This field is controlled by ourselves. TFS will not automatically change it.

    Firstly, what we need to do is to download and install Team Foundation Server Power Tools. We need the feature "Process Editor" inside to do the work.

    After we launch Team Explorer, please go to Tools menu >> Process Editor >> Work Item Types >> Open WIT from Server. We will get Work Item Type Editor.

    In Field tab, click "New" to create a new field. You can enter the information of this new ID field.
    (Note: For "RefName", you can enter any name you want.)

    Then go to Layout tab, add this field onto the work item dialog box.

    Then refresh Team Explorer.

    When you create a new Work Item, you will get "Item ID" field in the Work Item dialog box.
    When you save the work item, the "Item ID" data will be saved into the database on your server.

    Hope this helps! If you have any concern, please feel free to let me know.

    Best regards,
    Yichun Chen
    MSDN Subscriber Support in Forum
    If you have any feedback on our support, please contact msdnmg@microsoft.com
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Edited by YiChun Chen Thursday, June 03, 2010 10:22 AM typo
    • Marked as answer by YiChun Chen Wednesday, June 09, 2010 10:00 AM
    Thursday, June 03, 2010 10:20 AM
  • Hi Dan,

    I'm writing to follow up the post. Does the above suggestion work?

    Please feel free to let me know if you need any help.

    Best regards,
    Yichun Chen
    MSDN Subscriber Support in Forum
    If you have any feedback on our support, please contact msdnmg@microsoft.com
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Monday, June 07, 2010 9:40 AM
  • Hi Dan,

    I've marked my reply as answer. If you have any concern, you can unmark my reply and let me know.

    Have a nice week!

    Best regards,
    Yichun Chen
    MSDN Subscriber Support in Forum
    If you have any feedback on our support, please contact msdnmg@microsoft.com
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Wednesday, June 09, 2010 10:00 AM