G Tech

IT stuff that is easy to forget or just don't want to remember.

Monday, September 10, 2007

MS SQL - Reseting IDENTITY value

If you want to reset your identity field to a certain number, use the following statement:

DBCC CHECKIDENT ('tablename', RESEED, new identity value)
Posted by G at 12:49 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2011 (1)
    • ►  January (1)
      • ►  Jan 14 (1)
  • ►  2010 (5)
    • ►  September (1)
      • ►  Sep 03 (1)
    • ►  August (1)
      • ►  Aug 16 (1)
    • ►  February (2)
      • ►  Feb 14 (1)
      • ►  Feb 10 (1)
    • ►  January (1)
      • ►  Jan 28 (1)
  • ►  2009 (5)
    • ►  October (1)
      • ►  Oct 05 (1)
    • ►  June (1)
      • ►  Jun 17 (1)
    • ►  April (1)
      • ►  Apr 30 (1)
    • ►  February (1)
      • ►  Feb 26 (1)
    • ►  January (1)
      • ►  Jan 21 (1)
  • ►  2008 (10)
    • ►  December (3)
      • ►  Dec 19 (3)
    • ►  September (1)
      • ►  Sep 11 (1)
    • ►  January (6)
      • ►  Jan 13 (1)
      • ►  Jan 12 (2)
      • ►  Jan 06 (1)
      • ►  Jan 01 (2)
  • ▼  2007 (26)
    • ►  November (1)
      • ►  Nov 06 (1)
    • ►  October (2)
      • ►  Oct 26 (1)
      • ►  Oct 12 (1)
    • ▼  September (8)
      • ►  Sep 19 (1)
      • ►  Sep 16 (1)
      • ▼  Sep 10 (3)
        • ASP.NET and MS SQL Server 2005 - Bit / Boolean Type
        • Dreamweaver - Centering Layouts
        • MS SQL - Reseting IDENTITY value
      • ►  Sep 08 (1)
      • ►  Sep 03 (2)
    • ►  August (2)
      • ►  Aug 31 (1)
      • ►  Aug 02 (1)
    • ►  July (13)
      • ►  Jul 25 (2)
      • ►  Jul 24 (2)
      • ►  Jul 13 (1)
      • ►  Jul 12 (8)
Picture Window theme. Theme images by fpm. Powered by Blogger.