Msg 102, Level 15, State 1, Line 5
Incorrect syntax near ';'.

-- Default for user options is 0
-- See http://msdn.microsoft.com/en-us/library/ms189631.aspx
-- Flag values are at http://msdn.microsoft.com/en-us/library/ms176031.aspx
-- e.g. QUOTED_IDENTIFER is 256
SELECT
    c.value_in_use 
FROM sys.configurations AS c
WHERE
    c.name = N'user options';

-- Show database-level defaults
SELECT 
    name, is_quoted_identifier_on
FROM sys.databases AS d;

-- Is QUOTED_IDENTIFIER on for the current connection?
-- A value of 256 means yes
-- See http://msdn.microsoft.com/en-us/library/ms177525.aspx
SELECT @@OPTIONS & 256;