I have a number of servers that I need to monitor, both SQL Server 2000 and 2005.  I use similar code with an SSIS package to collect this information from...

The fileproperty function needs to be used in the context of the database.  I plan to call this from an MS Access database (I will convert it to .Net later)...

Try this and compare it to the task pad view in Enterprise Manager.

 SELECT AA.name, AA.filename, -- AA.dbSize,

  BB.name, BB.filename, --BB.dbSize,

  (AA.dbSize) * CC.low / 1048576 AS DBSize, -- This is the...