Search code examples
settingssql-server-2000

SET QUOTED_IDENTIFIER ON default setting is saved where

I need to find out the default quoted_identifier setting for a SQL Server 2000 database. @@options exist for SQL Server 2008 R2 (and on) but I need to figure out what the setting is for a SQL Server 2000 database via T-SQL.

Solution

  • I don't have an instanse of SQL Server 2000, so can't test the result. The only solution I found was to check with

    OBJECTPROPERTY(object_id,'ExecIsQuotedIdentOn')

    For example: 

    SELECT  
    SCHEMA_NAME(s.schema_id)  + '.' + s.name AS name,
    s.create_date, 
    s.modify_date, 
    OBJECTPROPERTY(s.object_id,'ExecIsQuotedIdentOn') AS IsQuotedIdentOn
FROM sys.objects s  
WHERE  
    s.type IN ('P','TR','V','IF','FN','TF')
    AND OBJECTPROPERTY(s.object_id,'ExecIsQuotedIdentOn') = 0
ORDER BY SCHEMA_NAME(s.schema_id)  + '.' + s.name DESC

    Hope this helps.