Question: I've read your post on Enable XA transactions for SQL Server , which outlines how to enable XA transactions via the Computer Services module. I'd like to integrate the enabling of XA transactions as part of a scripted SQL Server installation, whoch includes enabling XA transactions for some applications.

I'm using Powershell to develop the script . How can I see the current value and also change the value to enable XA ?

Answer: It is possible to access and set the MSDTC XA Transactions values using Powershell . You need to make sure your current login has the correct permissions.

To view the current XA transactions value use the following Get-ItemProperty command