poniedziałek, 11 lutego 2008

How to reset identity seed in Sql Server

Sometimes you need to reset indentity seed in your database table. There is a nice way to achive that (sql command):

DBCC CHECKIDENT('table_name', RESEED, 0)