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
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
This entry was posted in SQL Server, Transactional SQL. Bookmark the permalink. Both comments and trackbacks are currently closed.
The New Blog
A Quote..
"A man who has not passed through the inferno of his passions has never overcome them. They then dwell in the house next door, and at any moment a flame may dart out and set fire to his own house."
C.G.Jung
Blogroll
Archives
Old Random Projects
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