Disco Octopus (di****************@yahoo.com) writes:
I would like to know how to get a list of configuration settings for a
database.
Is there a table that I can select this info from?
Or a file (perhaps an ini file?) of some kind?
Things like timeout settings, rollback space, table space, etc.
In addition to sp_dboption and sp_configure, there is also DBCC USEROPTIONS.
There are also special functions to retrieve some of this data, or you
find it in system table. There is not really any one-stop shopping here.
And some of the examples you gave are not really relevant, rollback
space for instance.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp