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) |
|