SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


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, 1,404 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, 1,178 reads

Posted in SQLREPL on 20 May 2011