Re: Setting SEED value for a existing column

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: SouRa (SouRa_at_discussions.microsoft.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 02:41:03 -0800

hi,
Actually, In order to avoid the insertion conflict, I set even values for
identity column
in publisher and Odd value for the Subscriber(max of that column as seed).
So I need to set SEED values for each and every identity columns through
Enterprise
Manager. For that, I am searching a easy way to set SEED (through Query).
I have used the following,

DBCC CHECKIDENT (jobs, RESEED, 30)
the seed value is changed but the Enterprise Manager still shows the old SEED
value.
For example, i checked the seed with
DBCC CHECKIDENT (jobs, NORESEED)
it shows 20 as seed and I reset the seed from 20 to 30 by Query
DBCC CHECKIDENT (jobs, RESEED, 30)
Now
DBCC CHECKIDENT (jobs, NORESEED)
returns 30 as seed but E.M still shows 20 as Seed

Thanks,
Soura

"Paul Ibison" wrote:

> Soura,
> can you explain a little more about your replication scenario, and why this
> reseeding is necessary. You may have stumbled across something I have seen
> once before - note that according to BOL, DBCC CHECKIDENT is not supported
> for identity columns created with the NFR flag. In every case I have tried,
> contrary to BOL it does indeed work, but in the early days I had a column
> where it didn't work, and unfortunately I didn't document it, so further
> info on your situation would be welcome. Also, please do an insert yust to
> confirm that the reseeding hasn't taken place.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>

Relevant Pages

  • RE: How to reset an Identity column?
    ... Truncating the table will reset as Keith suggests ... IDENT_CURRENT and DBCC CHECKIDENT from BOL these are very helpfull with ... identity columns. ... DBCC CHECKIDENT ...
    (microsoft.public.sqlserver.server)
  • Re: Setting SEED value for a existing column
    ... can you explain a little more about your replication scenario, ... for identity columns created with the NFR flag. ... confirm that the reseeding hasn't taken place. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Strange behavior with identity columns...any advice?
    ... Jonathan Furman wrote: ... > I've just run into a strange issue with identity columns and reseeding ... What's the problem with it reseeding, even if it uses a different ...
    (microsoft.public.sqlserver.programming)