displaying database options

What tsql command can I use to display what database options are in
affect? Such as ansi nulls, ansi warnings, etc. sp_dboption gives me
a list, but doesn't tell me their values.
Thanks,
waltmallon@.yahoo.com<waltmallon@.yahoo.com> wrote in message
news:1115834655.031449.34870@.g44g2000cwa.googlegroups.com...
> What tsql command can I use to display what database options are in
> affect? Such as ansi nulls, ansi warnings, etc. sp_dboption gives me
> a list, but doesn't tell me their values.
did u try:
exec sp_dboption 'db_name'|||That works. Thanks. Are there any other commands, such as DBCC
commands, that display this information?
Thanks alot!
Walter|||dbcc useroptions
this is cnnection-specific so can differ between clients and has no direct
relationship to options set at the database level if they have changed by
this connection prior to running the statement...
<waltmallon@.yahoo.com> wrote in message
news:1115835691.445076.292710@.g43g2000cwa.googlegroups.com...
> That works. Thanks. Are there any other commands, such as DBCC
> commands, that display this information?
> Thanks alot!
> Walter
>

displaying database options

What tsql command can I use to display what database options are in
affect? Such as ansi nulls, ansi warnings, etc. sp_dboption gives me
a list, but doesn't tell me their values.
Thanks,
waltmallon@.yahoo.com
<waltmallon@.yahoo.com> wrote in message
news:1115834655.031449.34870@.g44g2000cwa.googlegro ups.com...
> What tsql command can I use to display what database options are in
> affect? Such as ansi nulls, ansi warnings, etc. sp_dboption gives me
> a list, but doesn't tell me their values.
did u try:
exec sp_dboption 'db_name'
|||That works. Thanks. Are there any other commands, such as DBCC
commands, that display this information?
Thanks alot!
Walter
|||dbcc useroptions
this is cnnection-specific so can differ between clients and has no direct
relationship to options set at the database level if they have changed by
this connection prior to running the statement...
<waltmallon@.yahoo.com> wrote in message
news:1115835691.445076.292710@.g43g2000cwa.googlegr oups.com...
> That works. Thanks. Are there any other commands, such as DBCC
> commands, that display this information?
> Thanks alot!
> Walter
>

displaying database options

What tsql command can I use to display what database options are in
affect? Such as ansi nulls, ansi warnings, etc. sp_dboption gives me
a list, but doesn't tell me their values.
Thanks,
waltmallon@.yahoo.com<waltmallon@.yahoo.com> wrote in message
news:1115834655.031449.34870@.g44g2000cwa.googlegroups.com...
> What tsql command can I use to display what database options are in
> affect? Such as ansi nulls, ansi warnings, etc. sp_dboption gives me
> a list, but doesn't tell me their values.
did u try:
exec sp_dboption 'db_name'|||That works. Thanks. Are there any other commands, such as DBCC
commands, that display this information?
Thanks alot!
Walter|||dbcc useroptions
this is cnnection-specific so can differ between clients and has no direct
relationship to options set at the database level if they have changed by
this connection prior to running the statement...
<waltmallon@.yahoo.com> wrote in message
news:1115835691.445076.292710@.g43g2000cwa.googlegroups.com...
> That works. Thanks. Are there any other commands, such as DBCC
> commands, that display this information?
> Thanks alot!
> Walter
>