[dba-SQLServer] Administration script...

Francisco Tapia fhtapia at gmail.com
Tue Feb 15 18:35:54 CST 2005


generally this info is sufficient
USE master
EXEC sp_configure 'show advanced option', '1'
but other times it is useful to pickup some extra information about
"YOUR" current configuration.

One idea is to loop through each of the db's given by the master
system tables to locate each database name and gain the info by
running it against something like DBCC SHOWFILESTATS.

I'm curious to know what kind of monitoring or scripting you do for
your enterprise / soho.
-- 
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...



More information about the dba-SQLServer mailing list