Current identity value is set to the new_reseed_value. If no rows have been inserted into the table since the table was created, or if all rows have been removed by using the TRUNCATE TABLE statement, the first row inserted after you run DBCC CHECKIDENT uses new_reseed_value as the identity. Otherwise, the next row inserted uses new_reseed_value + the current increment value.
If the table is not empty, setting the identity value to a number less than the maximum value in the identity column can result in one of the following conditions:
| Bloke walks into a brothel and says "I like it a bit kinky, how much for total humiliation?"The Madam replies "£37.50""Blimey" says the bloke "what do I get for that?"The Madam looks at him and replies "an England shirt" |
Don't be fooled!
Real R200:
Fake R200: