Sysfiles table Update

• tomhughes

  SSC Rookie

  Points: 46

  More actions

  July 28, 2003 at 12:32 pm

  #82924

  The sysfiles table seems to be used alot to determine database size.

  Under what conditions is it updated?

  (attach,restore,daily at a specific time..?)

  I am using this table to provide feedback to the user if their database size exceeds a limit. I need to make sure all the bases are covered.

  Thanks

  Tom Hughes

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  July 28, 2003 at 2:10 pm

  #467361

  To be sure you have the last status, you can capture the output of the sp_helpdb to check the size of your dbs.

  You can also use xp_fixeddrives to check free space in all your disks.