Home Forums Article Discussions Article Discussions by Author Discuss content posted by Nicholas Williams Database Growth History RE: Database Growth History
Leon . Orlov .
Ten Centuries
Points: 1212
More actions
February 3, 2014 at 9:16 am
#1685543
Thanks for sharing. Cool script.
You also might want to limit the data collection for only 'ONLINE' databases.
SELECT [name] FROM master.dbo.sysdatabases
WHERE DATABASEPROPERTYEX(name, 'status') = 'ONLINE'
ORDER BY [name]
OPEN file_cursor
~Leon