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

SESSIONPROPERTY
Returns the SET options settings of a session. Syntax
SESSIONPROPERTY ( option ) Luis Martin
Moderator
SQL-Server-Performance.com 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.

SELECT SESSIONPROPERTY (‘QUOTED_IDENTIFIER’)
Madhivanan Failing to plan is Planning to fail

]]>