RSS

Monthly Archives: August 2013

Check the status of SQL Server Setting

When we need to Work in SQL Server we Must know What the Status of SQL Server Setting is Enabled or Disabled  this Setting like

  • QUOTED_IDENTIFIER
  • ARITHABORT
  • ANSI_NULL_DFLT_ON
  • ANSI_WARNINGS
  • ANSI_PADDING
  • CONCAT_NULL_YIELDS_NULL
  • ANSI_NULLS

Now How i Can Know if (QUOTED_IDENTIFIER) is Enabled or Disabled in My SQL Server Session before i Run my Query we Can use System Function SESSIONPROPERTY to know if (QUOTED_IDENTIFIER)  is ON or OFF .

Example :


SELECT SESSIONPROPERTY('QUOTED_IDENTIFIER')

1

If the Statement Return 1 that’s meaning is QUOTED_IDENTIFIER Setting is ON  in This Session otherwise is OFF that’s meaning  The QUOTED_IDENTIFIER Setting is OFF

 
Leave a comment

Posted by on August 16, 2013 in General topics

 

Tags: