I have not found a solution as yet...
I am Just maintaining the Logs by using sp_repldone and then shrinkfile..
Any solutions...?
I see the 2 subscribers are continually running and these are the ones that open up the transaction(begin tran)
One more thing: This command "exec sp_executesql N'update MSreplication_subscriptions set transaction_timestamp " is running every second on the subscription database..
Maninder
www.dbanation.com