search or reseed identity columns in sqlserver 2008 //SeachDBCC CHECKIDENT ('AD_EmailType') --AD_EmailType : table name //Change DBCC CHECKIDENT('AD_EmailType', RESEED,4)