DBCC commands

• dbcc useroptions -- This command is used to display the current user settings for that connection
• 
  

select * from sys.dm_exec_sessions

This displays all the user sessions connected to the sql server and different options made with the session.