Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitor database size with dbcc showfilestats Expand / Collapse
Author
Message
Posted Thursday, October 11, 2007 3:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:01 PM
Points: 125, Visits: 55
Comments posted to this topic are about the item Monitor database size with dbcc showfilestats


Post #409404
Posted Thursday, February 9, 2012 7:16 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, November 20, 2014 8:57 PM
Points: 480, Visits: 215
If your are NOT using a sysadmin login, wich permissions do you need to run DBCC showfilestats?
Post #1249684
Posted Thursday, July 25, 2013 5:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 10:51 AM
Points: 8, Visits: 22
Another implementation since we are using root level commands:

EXECUTE sp_MSforeachdb 'USE [?]; dbcc showfilestats'
Post #1477805
Posted Thursday, July 25, 2013 5:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2014 10:51 AM
Points: 8, Visits: 22
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.
Post #1477807
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse