-
Identity Seed
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|