Wednesday, February 8, 2012

DBCC CHECKIDENT

We can find the current identity seed by using DBCC checkident .


DBCC checkident (#a)
if we execute above query than we will find like below:
Checking identity information: current identity value 'some number', current column value '
some number'.




DBCC CHECKIDENT ('tablename', 'RESEED', rowid)
Ex:DBCC CHECKIDENT ('IC_Request', 'RESEED', 2)
 
'table_name'
It Is the name of the table for which to check the current identity value .
RESEED
Specifies that the current identity value should be corrected.

No comments:

Post a Comment

Comments

Search

Custom Search
Protected by Copyscape Plagiarism Software