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...