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
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?
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.
View Complete Post