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 Rossi
Microsoft 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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy