sql server replication: ALTER TABLE ALTER COLUMN -- sql server replication

Re: ALTER TABLE ALTER COLUMN

pheckz NO[at]SPAM hotmail.com
8/7/2003 6:43:51 PM

sql server replication:

You cannot change the identity property of the field once it is
subscriber or a publisher. You can can only changed the seed and the
deafult value. I did not know if Ms allow it in SP3.

[quoted text, click to view]

ALTER TABLE ALTER COLUMN

Adam Right
8/7/2003 7:10:08 PM

Heya,

I have table STOKMOTION with field described as;
[INCREMENT] [numeric](18, 0) IDENTITY (1, 1) NOT NULL

Now I want to make add NOT FOR REPLICATION statement and tried below;

ALTER TABLE STOKMOTION ALTER COLUMN [INCREMENT] [numeric](18, 0) IDENTITY
(1, 1) NOT NULL NOT FOR REPLICATION
and it failed with below error:

Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'IDENTITY'.

How can I make it work ?

Thnks & BRgds.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.