Solved

Identity Seed value

Posted on 2013-10-24
3
226 Views
Last Modified: 2013-11-08
Is there a way to set, on a database basis, the seed value and increment for identity columns?    

Also, I have a set of tables that at some point the seed value seems to have been set to 10000, with increment of 1.   Can a backup/restore cause this?    Can this easily be done, inadvertently?
0
Comment
Question by:HLRosenberger
[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
3 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 39598714
This is how to do it: http://technet.microsoft.com/en-us/library/ms176057(v=sql.100).aspx

<< Can a backup/restore cause this? >>


A restore yes, however that is unlikely to go silent in my opinion as you must restore the entire database since 2000 and up.
0
 
LVL 5

Expert Comment

by:MohitPandit
ID: 39599829
Hello,

yes, we can achieve customize script or settings (also with DBCC CHECKIDENT).

Could you please let us know exactly, what do you want based on that will create small snippet and will share with you?

Best Regards,
Mohit Pandit
0
 
LVL 1

Author Closing Comment

by:HLRosenberger
ID: 39634496
Thanks
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

728 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