ANSI Questions

I have a 6.5 and 2000 db that allows over flow of data to be entered into the
fields, but I have another 2000 db that does not allow over flow of data to
be entered. How can I check the ansi_defaults in the db's? I went through
the book ol but it didn't explain how to see those values. Only how to set
it using the SET option. Which was SET ANSI_DEFAULTS off go. Does it set
it for the whole db or just my session? I need to
change it for all logins to be consistant. Thanks.
New SQL Server DBA
Hi,
"SET commands are just activated only for that specific session not for the
entire database."
For database level see the ALTER DATABASE and use below options . This will
set database level.
ANSI_NULL_DEFAULT { ON | OFF }
| ANSI_NULLS { ON | OFF }
| ANSI_PADDING { ON | OFF }
| ANSI_WARNINGS { ON | OFF }
| ARITHABORT { ON | OFF }
Thanks
Hari
SQL Server MVP
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:2B1DC564-7FC0-40DF-A0AE-292D8840EDEE@.microsoft.com...
>I have a 6.5 and 2000 db that allows over flow of data to be entered into
>the
> fields, but I have another 2000 db that does not allow over flow of data
> to
> be entered. How can I check the ansi_defaults in the db's? I went
> through
> the book ol but it didn't explain how to see those values. Only how to
> set
> it using the SET option. Which was SET ANSI_DEFAULTS off go. Does it
> set
> it for the whole db or just my session? I need to
> change it for all logins to be consistant. Thanks.
> --
> New SQL Server DBA