SQL Server DBCC USEROPTIONS

SQL Server DBCC USEROPTIONS is a SQL statement in the Administration category. SQL Server: shows the current SET options active for the session (isolation level, language, etc.). The syntax is DBCC USEROPTIONS;. It returns session options. A typical example: DBCC USEROPTIONS; -- Returns: -- Set Option Value -- ---------------------- ----- -- textsize 2147483647 -- language us_english -- dateformat mdy -- datefirst 7 -- lock_timeout -1 -- quoted_identifier SET -- arithabort SET -- ansi_null_dflt_on SET -- ansi_warnings SET -- ansi_padding SET -- ansi_nulls SET -- concat_null_yields_null SET -- isolation level read committed -- Useful for debugging session configuration issues A close relative is CREATE USER, which creates a new database user account. A close relative is GRANT, which grants specific privileges (SELECT, INSERT, UPDATE, DELETE, ALL) to a user on a database/table. A close relative is REVOKE, which removes previously granted privileges from a user. More about this category: Database administration — CREATE DATABASE, GRANT, REVOKE, SHOW, DESCRIBE.