Sql 2016 replication immediate updating subscription

08-Dec-2016 18:59

If you're working with SQL Server 2016, choose your edition based upon your replication needs.

After Googl'ed for long time, I still did not get any clue.

SQL Server replication allows database administrators to distribute data across multiple servers throughout an organization.

You may wish to implement replication in your organization for a number of reasons, such as: There’s nothing preventing a single system from acting in both of these capacities.

I keep on getting this error OLE DB provider "SQLNCLI" for linked server "Server_2" returned message "No transaction is active.".

When I set up transactional replication with immediate updating subscription between two SQL Server 2K5, using EXEC sp_link_publication @publisher = 'Server1', @publication = 'Pub Update1',@publisher_db = 'Pub_DB',@security_mode = 0,@login = 'sa',@password = 'sa_pwd' on Server2, where the updatable subscribtion is located.

After Googl'ed for long time, I still did not get any clue.

SQL Server replication allows database administrators to distribute data across multiple servers throughout an organization.

You may wish to implement replication in your organization for a number of reasons, such as: There’s nothing preventing a single system from acting in both of these capacities.

I keep on getting this error OLE DB provider "SQLNCLI" for linked server "Server_2" returned message "No transaction is active.".

When I set up transactional replication with immediate updating subscription between two SQL Server 2K5, using EXEC sp_link_publication @publisher = 'Server1', @publication = 'Pub Update1',@publisher_db = 'Pub_DB',@security_mode = 0,@login = 'sa',@password = 'sa_pwd' on Server2, where the updatable subscribtion is located.

This means that the two MS DTC will not be able to communicate with each other.