Option to disable the SQL sp_refreshview command in the update script.
An option that prevents the addition of the EXEC sp_refreshview in the update script.
When updating queries that rely on linked servers and the linked server doesn't support distributed transactions the update fails and is rolled back.
Now we constantly have to manually alter the script by manually removing the EXEC sp_refreshview commands. This our server admins will not enable the DTC coordinator on the SQL servers
24
votes
J. de Graaf
shared this idea