-- 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;

Try connecting via sqlcmd instead of using SSMS. It does not SET QUOTED_IDENTIFIER ON unless you specify the -I switch, see http://msdn.microsoft.com/en-us/library/ms162773.aspx