Home Forums Article Discussions Article Discussions by Author Discuss content posted by Irwan Tjanterik Track database growth RE: Track database growth
wmt
SSChasing Mays
Points: 602
More actions
February 23, 2010 at 8:27 am
#1123640
Great script.
For the database name problem, all you have to do is use the QUOTENAME function i.e.
SET @sql = 'USE ' + QUOTENAME(@dbname) + 'DBCC SHOWFILESTATS WITH NO_INFOMSGS'
works for me.