SQL Server/T-SQL Tutorial/System Settings

• ANSI_NULLS
• CONNECTIONS
• CPU_BUSY
• DBCC
• DB_ID
• ERROR
• ERROR_NUMBER
• ERROR_SEVERITY
• FORCEPLAN
• HOST_ID
• HOST_NAME
• HashBytes
• IDLE
• IO_BUSY
• Information_schema
• LANGID
• LOCK_TIMEOUT
• NESTLEVEL
• NOCOUNT
• OBJECTPROPERTY
• OBJECT_ID
• OBJECT_NAME
• PACKET_ERRORS
• PACK_RECEIVED
• PACK_SENT
• QUOTED_IDENTIFIER
• ROWCOUNT_BIG
• SERVERNAME
• SERVERPROPERTY
• SERVICENAME
• SESSIONPROPERTY
• SESSION_USER
• SHOWPLAN_TEXT
• SPID
• SUSER_ID
• SUSER_NAME
• TIMETICKS
• TOTAL_ERRORS
• TOTAL_READ
• TOTAL_WRITE
• VERSION
• XACT_ABORT
• rowcount
• xp_cmdshell
• xp_msver
• xp_sendmail