Re: XML columns failing to Replicate
Hilary Cotter
Hi Grant - it works for me - here is a repro
--can you provide us with a table script, publication and subscription script as well as how you do the update.
Thanks
create database MergeXML
GO
create database MergeXMLSub
GO
sp_replicationdboption 'MergeXML','merge publish','true'
GO
use MergeXML
GO
create table MergeXMLTable
(PK int not null primary key,
Charcol char(20),
XMLCol XML)
GO
sp_addmergepublication 'MergeXML'
GO
sp_addpublication_snapshot 'MergeXML'
GO
sp_addmergearticle 'MergeXML','MergeXMLtable','MergeXMLtable'
GO
sp_addmergesubscription 'MergeXML', @@servername, 'MergeXMLSub'
GO
--start agent
insert into MergeXMLTable (PK, Charcol,XMLCol) values(1,'test insert','<root><node1>value1</node1></root>')
GO
select * From mergexmlsub.dbo.mergexmltable
GO
update MergeXMLTable set XMLCol='<root><node1>value2</node1></root>'
GO
--run agent
select * From mergexmlsub.dbo.mergexmltable
GO
--successful