Best Way to Code

Problem:

When you try to create or update a work item in Team Foundation Server, and you get the following error message

Exception Message: Error converting data type bigint to int. (type SqlException)
SQL Exception Class: 16
SQL Exception Number: 8114
SQL Exception Procedure: prc_iCounterGetNext
SQL Exception Line Number: 0
SQL Exception Server: testtfs
SQL Exception State: 2
SQL Error(s):

Solution

1. Go to TFS Project Collection database (Tfs_DefaultCollection by default)
2. Change value WIT_WorkItemWatermark in table tbl_counter to any integer value that is not exceed maxInt32.