Skip to content

Instantly share code, notes, and snippets.

@sskset

sskset/switchs.sql

Created June 21, 2019 01:55
Show Gist options
  • Save sskset/838cc0d515a0de6f9d761bf7f00ecc67 to your computer and use it in GitHub Desktop.
Save sskset/838cc0d515a0de6f9d761bf7f00ecc67 to your computer and use it in GitHub Desktop.
Download ZIP
enable sql server rpc and disable distributed transaction
Raw
switchs.sql
-- Enable RPC calls
EXEC sp_serveroption Logging, 'RPC OUT', 'TRUE'
-- disable distributed transaction
EXEC sp_serveroption Logging, 'remote proc transaction promotion', 'FALSE'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment