DBCC CHECKIDENT (‘table_name’, reseed, 34)
If identity seed is set below values that currently are in table, it will violate the uniqueness constraint as soon as the values start to duplicate and will generate error.
I have created this blog to help those who are looking for a change in .Net. You can share your interview experience, problems and knowledge. Just mail your content at email@example.com. It will immediately published. Visit the blog for .Net FAQ,.Net interview questions,ASP .Net FAQ, C# .Net FAQ,ASP .Net interview questions, interview question on .Net, interview questions on C#.Before going to interview just go through the site.