RESEED identity column value

Madhu.b.rokkam
Posted by Madhu.b.rokkam under Sql Server category on | Points: 40 | Views : 2122
If you want to the index to start from 11 then

DBCC CHECKIDENT('TABLE NAME', RESEED, 10)

Comments or Responses

Posted by: T.saravanan on: 2/18/2011 Level:Silver | Status: [Member] [MVP] | Points: 10
Hi Madhu,

You did small mistake in your query...

DBCC CHECKIDENT ('TABLE NAME', RESEED, 10)

Kindly checked it out and change it.

Cheers :)


Posted by: Madhu.b.rokkam on: 2/18/2011 Level:Bronze | Status: [Member] [MVP] | Points: 10
Thanks Saravanan it's typo mistake.. Thanks for correcting that

Login to post response