Landry D. Salles Filho
October 11, 2007 at 3:09 am
Comments posted to this topic are about the item Monitor database size with dbcc showfilestats
February 9, 2012 at 7:16 am
If your are NOT using a sysadmin login, wich permissions do you need to run DBCC showfilestats?
Alberto De RossiMicrosoft Certified Solutions Associate - SQL Server Microsoft MVP - Data Platform Power BI User Group Lima - Community Leader
July 25, 2013 at 5:15 pm
Another implementation since we are using root level commands:
EXECUTE sp_MSforeachdb 'USE [?]; dbcc showfilestats'
July 25, 2013 at 5:27 pm
User must own the table, or be a member of the sysadmin fixed server role, the db_owner fixed database role, or the db_ddladmin fixed database role.
May 2, 2016 at 1:07 pm
Thanks for the script.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply