1. deepak.baran New Member

   Hi
   Is there anyway to rest the identity in sql server 2005. I want to generate receipt numbers for customers starting from 100001, 100002,..., 9999999. After recahing 9999999 it should again start form 100001.
   Please let us know how can this be done.
   Thanx..
   Deepak
   

   deepak.baran, Oct 26, 2009

   #2
2. FrankKalis Moderator

   Sorry, but the identity property is really a bad choice for what you are trying to do. There is no guarantee that identity values will be consecutive or even gapless. I would rather built my own logic upon a normal integer typed column.
   

   FrankKalis, Oct 27, 2009

   #3
3. Madhivanan Moderator

   I guess you need something like this
   http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57069
   

   Madhivanan, Oct 27, 2009

   #4
4. deepak.baran New Member

   Thanx for the help.
   

   deepak.baran, Oct 28, 2009

   #5

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in