Max. Number of servers a transaction can be propagated using DTC

The Issue: We recently worked on a customer issue, where a distributed SQL query was executed in a single transaction using  SQL  – SQL   as linked server. The 2nd SQL Server has about 80 linked servers defined to 80 different remote SQL Servers.  The distributed query updates a table, which has update trigger defined.  The…

0

Accessing rowset after committing a transaction

The rowset full functionality is either preserved or rowset enters into zombie state, after completing a transaction. If the rowset needs to be preserved after committing a transaction, to add or fetch new rows, delete or update existing, the cursor type must be explicitly set to use server side cursor in conjunction with preserve rowset…

0