Check the current Identity and Reset the Identity

Code Snippet:

// Check the current identity of the table

SELECT IDENT_CURRENT('tablename') 

 //Reset the identity to next incremental value

DBCC CHECKIDENT ('tablename', RESEED, 0)

When RESEED is used then the numbervalue in third argument of the CHECKIDENT is set as current identity for the table. Here in this case RESEED to 0 means