Create Database's default ANSI settings are off?

When I create a new database in SQL Server 2005, most of the database
Options settings, including all of the ANSI settings are off (False).
I thought that most of the ANSI settings (except NUMERIC_ROUNDABORT)
were recommended to be ON(True) by Microsoft. If that is so, then why
aren't they ON by default? I had thought that they were in SQL Server
2000.
Is this the correct behavior or is there a problem with my
installation?
Thanks, R Barry YoungHow are you creating it? Are you running a script? If so what tool are you
using? If it is the query editor then check your options and set them the
way you want them to be.
--
Andrew J. Kelly SQL MVP
<RBarryYoung@.gmail.com> wrote in message
news:1144864748.605738.232910@.e56g2000cwe.googlegroups.com...
> When I create a new database in SQL Server 2005, most of the database
> Options settings, including all of the ANSI settings are off (False).
> I thought that most of the ANSI settings (except NUMERIC_ROUNDABORT)
> were recommended to be ON(True) by Microsoft. If that is so, then why
> aren't they ON by default? I had thought that they were in SQL Server
> 2000.
> Is this the correct behavior or is there a problem with my
> installation?
> Thanks, R Barry Young
>