SQL Server DBA

SQL Server Database Administration Quick Reference

Question

Which command lists the active SET options for the current connection?

Answer

DBCC USEROPTIONS — DBCC command, session/activity. Returns the current session’s SET option names and values, including ANSI settings, isolation level, language, and date format.

This is 24 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples