Remove DTC Support From SQL Server 2016
1
vote
0
answers
359
views
My application is running in Azure SQL which doesn't support DTC. We only use Azure SQL in upper environments. In the local development environments, we're still using SQL Server 2016.
I want to avoid a situation, which has happened a couple of times in past where a developer has ended up writing queries with a transaction that ended up escalating to DTC, which of course was only caught in upper environments.
I'm looking for a command to run in SQL Server to completely remove its ability to participate in DTC, basically make it like its Azure SQL counterpart.
Edit: I don't want to remove MSDTC from the system itself as I've other services, that doesn't involve Database, that requires MSDTC.
Asked by postmeterparkingapp
(11 rep)
Aug 23, 2019, 01:39 PM
Last activity: Aug 23, 2019, 02:04 PM
Last activity: Aug 23, 2019, 02:04 PM