[reposted from comp.databases.ms-sqlserver] - sorry
Hi,
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.
ThanksHi,
Server wide parameters will be in MASTER database , sysconfigures tables
You can either use
select * from master..sysconfigures
or use
sp_configure system procedure to view and change parameters.
Database informations:-
You can get the database informations like, number of file groups (Table
space in oracle) from sysfiles tables of each database.
use <dbname>
go
select * from sysfiles
Thanks
Hari
MCDBA
"Disco Octopus" <discooctopusN05PAM@.yahoo.com> wrote in message
news:h_MEc.118$qd4.9010@.news.optus.net.au...
> [reposted from comp.databases.ms-sqlserver] - sorry
> Hi,
> 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.
> Thanks
>|||run sp_helpdb in Query Analyzer and look at the status field
can do individually and do sp_helpdb <dbname> . ie sp_helpdb pubs
Or in Enterprise Manager , select database and change the default view to
Taskpad as well as Right Click / Properties and Options.
cheers,
Andy.
"Disco Octopus" <discooctopusN05PAM@.yahoo.com> wrote in message
news:h_MEc.118$qd4.9010@.news.optus.net.au...
> [reposted from comp.databases.ms-sqlserver] - sorry
> Hi,
> 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.
> Thanks
>
Thursday, March 29, 2012
configuration settings for a database
Labels:
91reposted,
adatabase,
comp,
configuration,
database,
databases,
microsoft,
ms-sqlserver,
mysql,
oracle,
server,
settings,
sorryhi,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment