SQL Server and BI Tools

Thursday, August 11, 2011

How to reset Identity value in SQL Server Table

DBCC CHECKIDENT ('your table name',RESEED,new_seed_value)

Posted by Vinod Sharma
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: How to Reset Identity value in SQL Server Table
Newer Post Older Post Home
  • Home

List of Topics to Visit

  • ►  2016 (6)
    • ►  May (6)
  • ►  2015 (31)
    • ►  November (2)
    • ►  October (20)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (6)
  • ►  2014 (3)
    • ►  September (1)
    • ►  May (2)
  • ►  2013 (6)
    • ►  October (1)
    • ►  July (1)
    • ►  May (2)
    • ►  April (2)
  • ►  2012 (24)
    • ►  November (3)
    • ►  June (7)
    • ►  May (3)
    • ►  April (9)
    • ►  January (2)
  • ▼  2011 (62)
    • ►  December (1)
    • ►  November (4)
    • ►  October (4)
    • ►  September (5)
    • ▼  August (10)
      • What’s new in Denali CTP3? -- SSIS
      • What’s new in Denali CTP3? -- SQL Server DB
      • Highlights on Denali (SQL Server 2011) Features
      • Simple way to take DB Backup
      • Different ways to Create SQL Table
      • How to populate Time Dimension:
      • How to Limit the No of Records Per Page in SSRS
      • How to reset Identity value in SQL Server Table
      • Tables or SP structure modified (IF)
      • How to findout which table modified Today
    • ►  July (4)
    • ►  June (10)
    • ►  May (9)
    • ►  April (3)
    • ►  February (12)
  • ►  2010 (38)
    • ►  December (4)
    • ►  November (7)
    • ►  October (25)
    • ►  July (1)
    • ►  March (1)

Admirers:

You are most welcome!

Hope you will like it...

Want to know about me?

My photo
Vinod Sharma
View my complete profile

Visited:

Search:
Powered By Blogger
All blogs content are based on understanding and also copied from various Informative URLs.... Powered by Blogger.