Check current SET vaues | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Check current SET vaues

hi, we can set parameters , eg: SET QUOTED_IDENTIFIER ON .
But how to check current value of QUOTED_IDENTIFIER . any idea ? -Rajiv
Returns the SET options settings of a session. Syntax
SESSIONPROPERTY ( option ) Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Madhivanan Failing to plan is Planning to fail