Using SQL 2005 SP2 on Windows 2003. I've got a database set up with
transactional replication. There's one text field that occasionally gets
updated with an UPDATETEXT statement. When I check the subscriber, it is
not receiving these changes. The UPDATETEXT statement has the WITH LOG
clause looking something like the below. Any ideas why changes are not
being replicated to the subscriber
Thanks
DECLARE @ptrval varbinary(16)
DECLARE @Descript nvarchar(254)
SELECT @Descript = ' ' + 'hello'
SELECT @ptrval = TEXTPTR(SITXT)
FROM Wo where Num = 13698
UPDATETEXT WO.SITXT @ptrval NULL NULL with log @Descript
Paul Ibison - 23 Aug 2008 18:12 GMT
It all needs to be done inthe same transaction - please have a look here for
more info: http://msdn.microsoft.com/en-us/library/aa237475.aspx
HTH,
Paul Ibison (www.replicationanswers.com)