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