Monitor database size with dbcc showfilestats

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Alberto dbLearner Ten Centuries Points: 1246 More actions · Answer 1

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

arooney SSC Rookie Points: 48 More actions · Answer 2

Another implementation since we are using root level commands:

EXECUTE sp_MSforeachdb 'USE [?]; dbcc showfilestats'

arooney SSC Rookie Points: 48 More actions · Answer 3

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.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

SSC Guru

Points: 76202

May 2, 2016 at 1:07 pm

Thanks for the script.