Need to Change the Identity Value

[Kenos]

Hello All

I have an Identity Field and it starts at 1
I want to set this value to 10000
Without inserting Data

The Identity Field is 2000 Now

These values are already created and have data in them

Can this be done?

Thanks In Advance

 

[cheyney]

in your table designer, set the identity seed to 10000

Cheyney

 

[tlbroadbent]

You can also use DBCC CHECKIDENT.

USE YourDatabase
GO
DBCC CHECKIDENT (YourTable, RESEED, 10000)
GO

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[Kenos]

Thank You tlbroadbent

This works well