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 DBAHi,
"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