Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version

How to Reset Identity Column Value In SQL Server without Delete Records.

, 17 Dec 2010
You have deleted some records from different record position from your identity column table and you wan to reset it without delete records.
No downloads associated with this content

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Abdul Quader Mamun
Team Leader
Bangladesh Bangladesh
I have been developing software/web applications since 2002 mainly on Microsoft technologies.
 
I'm also experienced with other technologies.
 
I'm fan of well organized and effective coding.
 
A wide range of technologies, tools, languages, frameworks, components and design patterns I’m experienced with.
 
I’m a MCP, MCAD.NET, MCSD.NET.
Follow on   Google+

| Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 17 Dec 2010
Article Copyright 2010 by Abdul Quader Mamun
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid