Is there an easy way to reseed an identity column in a table? The only way I know of is to explicitly insert the value into the table using SET IDENTITY_INSERT ON/OFF. For example, if I wanted to reset the value to 5, I could insert 4 into the table and then delete the row. The next inserted row will start at 5. Is there a better way?