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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy