Very Computer

by **Ron Paskowsk** » Wed, 16 Apr 2003 23:02:16

I have setup two SQL2000 Servers to use Transactional Replication which is
working fine with the test database I setup. I have also setup the servers
to use IPSEC when communicating, works fine.

I am wondering why when I make a structure change to a table (adding a new
field) that the only way to get it to replicate is to create a new
subscription?

When I make a change to a table on SQLSRVR1 (Pub), should I also make the
table change on SQLSRVR2 (Subscriber) for it to work or am I just missing
something?

Thanks in advance

by **TSVK [MSFT** » Thu, 17 Apr 2003 12:53:50

The only supported structure changes are add and drop column
which need to be done thru
sp_repladdcolumn and sp_repldropcolumn on publisher which propagate as DDL
changes to subscriber.
Check booksonline for documentation

> I have setup two SQL2000 Servers to use Transactional Replication which is
> working fine with the test database I setup. I have also setup the servers
> to use IPSEC when communicating, works fine.

> I am wondering why when I make a structure change to a table (adding a new
> field) that the only way to get it to replicate is to create a new
> subscription?

> When I make a change to a table on SQLSRVR1 (Pub), should I also make the
> table change on SQLSRVR2 (Subscriber) for it to work or am I just missing
> something?

> Thanks in advance

Very Computer

Table Structure not Replicated?

Table Structure not Replicated?

Table Structure not Replicated?