Post reply

change database options

  • June 26, 2006 at 10:16 am

    #168980

    Hello, I need to change two settings in one of our databases.  They are Arithabort, and quoted_identifier and need to be set to ON.   I will also need to verify the command after changing.   We are running SQL2000 SP4 standard Edition.  There are multiple databases (7) on the current server.  thanks, Dana

     

  • June 26, 2006 at 11:06 am

    #645881

    Okay. You stated what you need to do. So what's your question?

    -SQLBill

  • June 26, 2006 at 11:30 am

    #645889

    HOW?

     

  • June 26, 2006 at 1:23 pm

    #645910

    Use the ALTER DATABASE command to set them:

    ALTER DATABASE dbname

    SET Quoted_Identifier ON,

    Arithabort ON

    Then to test for them, check the DATABASEPROPERTYEX.

    SELECT DATABASEPROPERTYEX('dbname', 'IsQuotedIdentifierEnabled'),

    DATABASEPROPERTYEX('dbname', 'IsArithmeticAbortEnabled')

    0 = off

    1 = on

    -SQLBill

  • June 27, 2006 at 9:48 am

    #646106

    Thank you very much.

     

Viewing 5 posts - 1 through 4 (of 4 total)

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