Post reply

Quotes Identifire Default value

  • September 10, 2013 at 11:50 pm

    #277847

    Dear all

    We are using SQL 2012 Express edition & Enterprise edition. As per the http://technet.microsoft.com/en-us/library/ms174393.aspx default value for Quotesidentifier is ON. But when we create new db it shows DB properties - options - Quoted identifier Enabled = False.

    Please correct me if i am wrong. How to set it as default on.

    Regards

  • September 11, 2013 at 12:13 am

    #1649106

    dear all

    with existing settings when i create new procedure by default quoted identifier for this is 1.

    created procedure using -

    create procedure aa as

    print 'sss'

    Checked quoted identifier using -

    select *

    from sys.sql_modules

    WHERE uses_quoted_identifier = 1

  • September 12, 2013 at 1:53 pm

    #1649859

    Thanks for sharing!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply