SQL Server – Set Options – Detecting Current Settings

Background Set options can have devastating effect on SQL Server Operations.  I am too shamed to talk about once it bit me terribly. Other times, setting one or a couple of them helped us. Setting XACT_ABORT on is very important when changing data within Stored Procedure. Setting TRANSACTION ISOLATION LEVEL  to "read uncommitted" could possibly help … Continue reading SQL Server – Set Options – Detecting Current Settings