• The article is very informative.  It encompasses some deviation to using replication beyond the "out of the box" solution.  However, has Microsoft or anyone else thought about replication and XML?  With SQL 2005 containing an XML data type, how will conflict resolution be handled if the XML data becomes a database inside the record?

    We currently have a situation where the XML columns have become the bulk of the data in several databases.  While replication works great along with conflict replication in a traditional database, only replication works great with XML in the mix.  Our situation could, at a minimum, be considered field abuse and be gravitating toward worst practices, as a maximum.  If it is accepted that at the minimum this is not a best practice, then could it be impractical to store XML in a database that requires replication?  Should the best practice be the storing of data in a normalized database and return XML as needed?

     

    [font="Arial"]Clifton G. Collins III[/font]