Solved

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

Posted on 2006-06-19
2
1,486 Views
Last Modified: 2008-01-09
How to re-initialize Identity column without truncating table? can any one help!!!!!!!!!!
0
Comment
Question by:application1973
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 50 total points
ID: 16932479
dbcc checkident tablename (reseed, <new_seed>, <new_increment> )
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 16933237
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

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
EF5 How do I stop pre-compiled views? 8 57
Use SSRS to email customers? 4 30
Do not display comma when no last name 8 48
relocating SQL 2000 18 39
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question