SQL 2000 not for replication



Hi,

can you tell me please, is there a way to set "not for replication" flag on
existing table field (ID) which is
defined as identity and primary key, to N number of tables using sql script.
e.g.:

alter table tableForReplication
alter column
... and so on.

Thx.

Vedran


.



Relevant Pages

  • Re: Merge replication and conflict tables.
    ... that "Cannot alter column ... ... >You can't delete the conflict tables using EM, ... >publication SQL Server will detect these existing tables ... I configured a merge replication with pull ...
    (microsoft.public.sqlserver.replication)
  • merge replication and structure changes
    ... I'm using merge replication between SQL Server 2000 and MSDE. ... Drop or Alter column ...
    (microsoft.public.sqlserver.replication)
  • alter column
    ... I want to alter column that it's part of primary key. ... Before i run this script, ... The object 'PK_table1' is dependent on column 'column1'. ...
    (microsoft.public.sqlserver.programming)
  • Alter Column help
    ... My alter column code fails ... I don`t know what I am missing here. ... a primary key and all I want to do is make it an identity ... ALTER COLUMN History_ID integer IDENTITYNOT NULL ...
    (microsoft.public.sqlserver.programming)
  • Alter Column Help
    ... My alter column code fails ... I don`t know what I am missing here. ... a primary key and all I want to do is make it an identity ... ALTER COLUMN History_ID integer IDENTITYNOT NULL ...
    (microsoft.public.sqlserver.dts)