Home Forums Article Discussions Article Discussions by Author Discuss content posted by Simon Richards Managing Database Data Usage With Custom Space Alerts RE: Managing Database Data Usage With Custom Space Alerts
jswong05
Hall of Fame
Points: 3553
More actions
June 5, 2012 at 12:04 pm
#1497253
I would change f.size to f.maxsize. case when 0, -1 use f.size.
Also the 2005 table is sys.database_files. sys.sysfiles is only provided for backward compatibility.
Jasonhttp://dbace.us😛