Find it

ReSeed Identity column – TSQL

November 9, 2009

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. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

Got a Project?
Categories
Life:
Business:
Code:
Technology:
Travel
A Quote..
"A man who asks a foolish question is foolish for a minute, a man who doesn't ask a question will remain foolish for a life-time"
Unknown
Blogroll
  • Cara Nahaul
  • Mizanur Rahman
  • My Bookmarks
  • Niall Halsall
  • Rioja Hill
  • William Fish
  • Woody Hayday Flickr
    • Archives
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • September 2010
  • August 2010
  • July 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • July 2009
  • May 2009
  • April 2009
  • January 2009
  • December 2008
  • September 2008
  • August 2008
    • Random Projects
  • dubFiend
  • EPN RSS Translator
  • grabTabs for Chrome
  • HD Visualisations
  • Reddit Wallpaper Grabber
  • yes yes fancy dress
    • © Woody Hayday 2012