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
>

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
>

CREATE DATABASE

Is there any way to learn default settings for path where new database
will be created on server machine if I do not specify the path explicitly,
just running on client machine:
CREATE DATABASE [testdb]This is decided by either the
Default Data Directory (Right click server | Properties | Database Settings)
If that is empty then you will still be using the default dir (DATA) from
install time
In my case this would be
D:\Microsoft SQL Server\MSSQL\Data
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Vlad Gonchar" <VladG@.Frogware.com> wrote in message
news:OaoBReefDHA.1764@.TK2MSFTNGP09.phx.gbl...
> Is there any way to learn default settings for path where new database
> will be created on server machine if I do not specify the path explicitly,
> just running on client machine:
> CREATE DATABASE [testdb]
>
>