ANSI_NULL.

Hi Experts,

Two questions:

1. what is the default setting for SET ANSI NULL for all the sql
server(65,70,80,90,100)
2. How do I know the object(table) is created with which ANSINULL SETTING.
eg. i tried to create view on one of my table and then realize that it has
created with ansi_null off.

Please help.

Thanx.
Vinay
--
Thank you.
Regards,
Vinay Thakur

Vinay,

While I don't know the defaults offhand, there is a "gotcha" in the concept
of a "default setting" for SET ANSI_NULLS.

1) There is the SQL Server default that is used if a connecting client does
not secify a preference for the setting, and
2) There is the default setting the client (e.g., Query Analyzer/SS
Management Studio) uses, and overrides the server's default.

If the setting is important, as it appears that it is to you, then you need
to make sure all you servers and clients are configured properly.

--
Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org


"Vinay" wrote in message

> Hi Experts,
>
> Two questions:
>
> 1. what is the default setting for SET ANSI NULL for all the sql
> server(65,70,80,90,100)
> 2. How do I know the object(table) is created with which ANSINULL
> SETTING.
> eg. i tried to create view on one of my table and then realize that it has
> created with ansi_null off.
>
> Please help.
>
> Thanx.
> Vinay
> --
> Thank you.
> Regards,
> Vinay Thakur