Hi

I am new to posting questions on Forums, so hope you undestand.

I am using SQL Server 2000 and I am trying to change the identity seed in a table. I want to change this via a script. I have used the following command:

DBCC CHECKIDENT (dbo, RESEED, value)
where
dbo = the table in the database whose seed I want to change
value = the value I would like to change the value in Identity seed too.

I get the following result:
"Checking identity information: current identity value '100017140', current column value '100017148'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator."

Then when I go to the table --> right click --> desigh --> the identity seed has not changed to what the message above has said it has changed too.

I have tried refreshing the table but still no luck.

Can anyone help. I am looking to have the value to be changed in the design view for Identity seed.

Thanks.
A