This command gets the user options, including isolation level, language, dateformat, etc., for the current session:
DBCC USEROPTIONS WITH NO_INFOMSGS
SQL Server Technical Blog by a Microsoft Certified Professional in SQL Server - LEE HongLeung, Peter