Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1496
  • Last Modified:

How to re-initialize Identity column without truncating table? can any one help!!!!!!!!!!

How to re-initialize Identity column without truncating table? can any one help!!!!!!!!!!
0
application1973
Asked:
application1973
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
dbcc checkident tablename (reseed, <new_seed>, <new_increment> )
0
 
LowfatspreadCommented:
what exactly do you wish to accomplish?

AngelIII's code will reset an identity Value to the new (new_seed) value if the identity does not have the NOT FOR REPLICATION clause  also specified on it...

do you want to reset a current identity value?
change the increment?
re-number all existing identity values?

...?

also which version / edition of SQL Server are we dealing with...?  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now