Is it possible to change an RTC work item ID in the back-end database using a SQL Server query?
Accepted answer
It might be possible, but there are no good reasons to attempt. The ID is updated on each new work item and I would expect that there are constraints that prevent "reusing" the ID so you couldn't change work item #100 to work item #10. Conversely, if the highest current id is 1000, changing some id to 1024 might break something in the future.
One other answer
Thanks guys. The plan was to delete an old work item, and replace a newer work item with the old ID. We needed to do this because a multi-select field on the old work item was set to medium size and running out of string bytes. I did a quick search of the CCM database and was unable to find the data I was looking for.
We are going with a different solution that does not involve changing back-end data. Thanks again!
We are going with a different solution that does not involve changing back-end data. Thanks again!