Search notes:
SSMS Menu: Tools -> Options -> Query Execution -> SQL Server -> Advanced
Tools -> Options -> Query Execution -> SQL Server -> Advanced allows to specify «advanced» execution settings:
SET
-
NOCOUNT
-
NOEXEC
-
PARSEONLY
-
CONCAT_NULL_YIELS_NULL
-
XACT_ABORT ON
-
ARITHABORT
-
SHOWPLAN_TEXT
-
STATISTICS TIME
-
STATISTICS IO
SET TRANSACTION ISOLATION LEVEL:
-
READ COMMITTED
-
READ UNCOMMITTED
-
REPEATABLE READ
-
SERIALIZABLE
SET LOCK TIMEOUT:
SET QUERY_COVERNOR_COST_LIMIT
Other settings:
- Suppress provider message headers
- Disconnect after the query executes
- Suppress error messages from unsupported settings