Msg 3609, Level 16, State 1, Line 1The transaction ended in the trigger. publisher is one which is the primary data which publish data to its subscribers and in your case updates at the subscibe are also results o update on primary.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
Enable updating subscriptions for transactional publications on the Publication Type page of the New Publication Wizard.
To use updating subscriptions, you must also configure options in the New Subscription Wizard.
--Declarations for adding a transactional publication DECLARE @publication DB AS sysname; DECLARE @publication AS sysname; DECLARE @login AS sysname; DECLARE @password AS sysname; SET @publication DB = N' Adventure Works2012'; SET @publication = N' Adv Works Product Tran'; SET @login = $(Login); SET @password = $(Password); USE [Adventure Works] -- Enable transactional replication on the publication database.