Jeff Roughgarden

Reset Identity Seeds

Resets the identity seeds for all user tables to one plus the current maximum value of the identity field. Revised 24 August 2010.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2006-08-14 (first published: 2006-07-06)

385 reads

SQL Server sa Account Security: Rename, Disable & Best Practices In...

Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...

No two SQL Server environments are alike. A fix that resolves a performance issue...

Comments posted to this topic are about the item Are You Working More Hours?

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

Comments posted to this topic are about the item A Limited Startup

I add this parameter to SQL Server 2025 in the Configuration Manager:

-mDynamics

What does this do?