Home Forums Reporting Services Reporting Services 2005 Administration Problems with transactional replication to a reporting server RE: Problems with transactional replication to a reporting server

  • February 21, 2013 at 9:01 pm

    #1590187

    have a read of http://msdn.microsoft.com/en-us/library/tcbchxcb(v=VS.80).aspx - has info on the implications of "SET TRANSACTION ISOLATION LEVEL SNAPSHOT".

    As for the way that replication handle transactions, launch Replication Monitor and change the profile associated with the distribution agent. The profile properties that you can set to change the way that replication uses transactions.