June 27, 2002 at 10:14 am
Hello everyone, I wanted to know how I can see which database and server options are set (through sp_dboption/alter database and sp_configure). I am not interested in finding this info in Enterprise Manager, I want to know what commands or tables will show me this info. Thanks in advance.
June 27, 2002 at 10:18 am
sp_configure gives server settings
sp_helpdb gives a bunch of db specifics. What are you looking for that is not covered?
Steve Jones
June 27, 2002 at 10:23 am
Thanks for the fast response Steve!
Yesterday I printed the BOL pages about sp_dboption and sp_configure and studied the different settings that can be set. But the BOL did not mention how I can check to see what options are set (at least not on the pages that I studied). I was curious to see what options are set for my database. How do I get a listing of my db options? Do I just run:
exec sp_dboption
Thanks again.
June 27, 2002 at 10:33 am
sp_helpdb has some of these.
I'm guessing these are properties of the database, maybe an extended properties seting.
Is this SQL 7 or 2000?
Steve Jones
June 27, 2002 at 11:01 am
We are using SQL 2000.
Other than sp_helpdb, is there any function I can run?
June 27, 2002 at 11:57 am
exec sp_dboption returns all database options that can be set
exec sp_dboption <DatabaseName> returns the options that are set for the database name provided
June 27, 2002 at 12:13 pm
Thank you!
June 28, 2002 at 1:58 pm
You can also look at running the following:
dbcc useroptions
in the database of interest.
HTH,
Steve Armistead,
Database Administration
Panther Systems Northwest, Inc.
Vancouver, WA
Steve
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply