The Stack Overflow podcast is back! Listen to an interview with our new CEO.
1

There is no real way to automate setting instance configuration settings that I am aware of without maybe some 3rd party tools, however, you could use this query, capture the results, then make the configuration changes on the new instance once installed to match manually via SSMS or T-Sql using those same settings. Select * from sys.configurations order by ...


1

Turns out it's a bug in sql server 2016 and java applications: https://support.microsoft.com/en-us/help/3145492/fix-xa-transactions-aren-t-cleaned-when-you-exit-a-java-application-in Trace flag has to be turned on to enable the fix (3924) Also there's a bug with that fix so make sure sql server is updated to the latest CU https://support.microsoft.com/en-...


Only top voted, non community-wiki answers of a minimum length are eligible