Tuesday, June 9, 2009

IDENT_CURRENT and dbcc Checkident

IDENT_CURRENT->
Returns the last identity value generated for a specified table in any session and any scope.
Select ident_current('Table_Name')
-> Checks the current identity value for the specified table and, if needed, corrects the identity value.
By using Following Syntax-
dbcc checkident (Table Name,Reseed,1020000)

No comments:

Post a Comment