Moved to: WoodyHayday.com
Woody Hayday

Fresh Ideas

Hi there! This is my old blog, I don't hang around here much.
You can now find me trying to mix things up here:
Visit WoodyHayday.com Subscribe To My Email List

ReSeed Identity column – TSQL

Randomly I didn’t remember the code to reseed the identity column in tsql, this works though on ms sql 2008 – DBCC CHECKIDENT (tbl_crazyTableName, RESEED, 20000)

TSQL
This entry was posted in SQL Server, Transactional SQL. Bookmark the permalink. Both comments and trackbacks are currently closed.
Woody Hayday

Comments Archive

Hi there. This is my old blog and it's archived, so you can no longer post new comments on this post (ReSeed Identity column – TSQL).

Read my new blog about writing software and stories at WoodyHayday.com

The New Blog
WoodyHayday.com
A Quote..
"There are certain things that are fundamental to human fulfillment. The essence of these needs is captured in the phrase "to live, to love, to learn, to leave a legacy." The need to leave a legacy is our spiritual need to have a sense of meaning, purpose, personal congruence, and contribution"
Stephen Covey
Old Random Projects
    © Woody Hayday 2008-2025