Prev: SQL 2008 to SQL 2000 Merge Replication
Next: Query Timeout Expired Error
From: LPR-3rd on 21 Jan 2010 15:29
All servers are running SQL 2005.

I have several remote locations that replicate via transactional
replication to a central location (NOLA), the SQL server @ NOLA
replications to the corporate office (CORP).

If I need to add a field @ the remote locations to a table, SQL 2005
will handle the replication of this addition to NOLA.

So my question is this, what happens when the other remote locations
replicate the field addition to NOLA, once it is already there??

AHIA,
Larry…
From: LPR-3rd on 4 Feb 2010 11:57
When adding the field on a remote server, the first subscriber to run
will replicate the change, when the field is added on another server,
it errors out because field names must be unique.
 | 
Pages: 1
Prev: SQL 2008 to SQL 2000 Merge Replication
Next: Query Timeout Expired Error