Reset Identity in SQL Server Tables of a Database

Run this command against your database:

exec sp_MSforeachtable 'IF OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasIdentity'') = 1 BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'

Print | posted on Sunday, February 14, 2010 7:47 AM

Comments on this post

No comments posted yet.

Title:

Name:

Email: (never displayed)

(will show your gravatar)

Website:

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Please add 8 and 1 and type the answer here:

Enter the code shown above: