Click here to Skip to main content
15,664,506 members
Please Sign up or sign in to vote.
0.00/5 (No votes)

Hey! I have been told that this command can reset the Identity column value (for a table called 'product') but it's not working. I am executing it in webmatrix on a sdf database and I get this:
There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = DBCC ]. What's the problem with DBCC?
Sergey Alexandrovich Kryukov 3-Mar-13 19:40pm    
Please stop posting non-answers as "solution". What is really amazing it that you even accepted some of your "answers" formally, "answering" your own question. It can give you abuse reports which eventually may lead to cancellation of your CodeProject membership.
Comment on any posts, reply to available comments, or use "Improve question" (above).
Also, keep in mind that members only get notifications on the post sent in reply to there posts.

1 solution

Have a try with a bit different syntax
DBCC CHECKIDENT ("product", RESEED, 999);

Also make sure that you have the sufficient privileges, namely one of these:
- sysadmin
- db_owner
- db_ddladmin
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900