none
Instance and Default connection properties on SQL Server 2005

    Question

  • We had a sql server fail and I have been having troubles.  I compared the connection properties on the server properties and noticed that multiple default settings are no longer set.  So I'm wondering if during the failure these could have some gotten flipped. 

    DB's that worked all of a sudden don't work and we had to migrate to a different instance.  I have never changed any of the setings below and wonder what impact they would have if I changed them back to the default of an installed instance?

    ansi warning is checked

    ansi padding is checked

    ANSI NULLS is checked

    arithmetic abort is checked

    quoted identified is checked

    No Count is checked

    concat null yields null is checked

    Could anyone tell me how clearing these checked options will impact my db?

     

    --
    Paul Bergson
    MVP - Directory Services
    MCITP: Enterprise Administrator
    MCTS, MCT, MCSE, MCSA, Security+, BS CSci
    2008, Vista, 2003, 2000 (Early Achiever), NT4
    http://www.pbbergs.com    Twitter @pbbergs

    Please no e-mails, any questions should be posted in the NewsGroup This
    posting is provided "AS IS" with no warranties, and confers no rights.

    Friday, August 20, 2010 9:05 PM

All replies

  • Hi,

     Pls check the link http://msdn.microsoft.com/en-us/library/ms177259.aspx for detils.

    Saturday, August 21, 2010 6:07 AM
  •  

    Please refer the SQL Options under Setting Database Options for the definition and how these setting will impact on ANSI-compliance.

     


    Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
    Saturday, August 21, 2010 10:09 AM
  • I appreciate you taking the time to point me to the websites, but I have already read all the details on them and have a decent understanding, but I want to know from someone who has played with them some informed feedback.

     

    --
    Paul Bergson
    MVP - Directory Services
    MCITP: Enterprise Administrator
    MCTS, MCT, MCSE, MCSA, Security+, BS CSci
    2008, Vista, 2003, 2000 (Early Achiever), NT4
    http://www.pbbergs.com    Twitter @pbbergs

    Please no e-mails, any questions should be posted in the NewsGroup This
    posting is provided "AS IS" with no warranties, and confers no rights.

    Saturday, August 21, 2010 12:18 PM
  • Hi Paul,

    Can you describe what you mean by "DB's that worked all of a sudden don't work and we had to migrate to a different instance." Did you receive specific errors?

    Thanks,

    Cathy Miller

    Microsoft Online Community Support

    Thursday, August 26, 2010 9:17 PM
    Moderator