Is it possible to seed a number that will become the next Request ID?
I see within SQL that this number is stored in the table dbo.HS_Request in the column xRequest. Can I enter a bogus request and then modify the number, or would this break anything?
Is there a more straightforward way to do this?
Tom V
Do you mean seed it so that they start higher? If so you should be able to run something like this:
DBCC CheckIdent (HS_Request,RESEED,12400)
Replacing 12400 with the number you want the next inserted value to be. You should not manually adjust the xRequest column as that will not have the effect you’re looking for.