Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLREPL

A blog about SQL Server Replication.

Archives: May 2011

Accidentally Dropped the Distribution Database

Have you made the mistake of dropping your distribution database like this?

If so, remember not to do this ever again.  Disabling publishing and distribution involves more than just dropping the distribution database.  The distribution database in SQL Server requires special attention and dropping it in this fashion can wreak… Read more

0 comments, 968 reads

Posted in SQLREPL on 28 May 2011

Replicating XML Columns

One caveat that’s worth mentioning is replicating the XML data type in SQL Server using Merge Replication.  Sometimes, when replicating a table that contains a column of type XML via a Merge Publication, the XML column data in updated rows sent from Publisher to Subscriber, and vice-versa, arrive at the… Read more

0 comments, 663 reads

Posted in SQLREPL on 20 May 2011