Posted by David Portas on 06/28/05 09:49

Lookup the DBCC CHECKIDENT command. Also, if you TRUNCATE rather than DELETE
then the IDENTITY will be reset to seed.

Why do you care what the IDENTITY value is? It's usually fatal to attach any
significance to the value assigned by IDENTITY. If you care about the value
then IDENTITY isn't the right solution.

--
David Portas
SQL Server MVP
--

• Next in forum: Re: Bulk Insert
• Prev in forum: Re: ADSI LDAP Query 1000 Record limit for MSSQLServer linked server
• Thread view: Re: How to Change AutoNumber Not Start From 1

[Reply to this message]