Checking and Changing Identity Seed using
DBCC CHECKIDENT... I recently had to change the properties of a column that was the PK in a table with about 2 million rows. Within SQL Server Studio (SQL Server 2005), modifying the table directly, would generate a sql server timeout error, no doubt due to the large number of rows. In order to change the indentity seed, I had to use a built in stored proc.
For checking:
DBCC CHECKIDENT ('TableName', NORESEED)
For Altering:
DBCC CHECKIDENT ('TableName', RESEED, Your#)I am posting this for my own reference because I had used this before and could not remeber the command and had a damn hard time finding it on Google.