Hi,
I´m looking for a SQL query to verify the NPM database size.
Thx.
why dont you do it via WMI?
e.g. you can execute this system stored procedure: exec sp_helpfile
thanks
Could you tell me how to sum the output data from this query ?
SELECT
[size] * 8
, [filename]
FROM sysfiles
Thanks.
If you need sum that per file try this one
SELECT SUM([size] * 8) , [filename]FROM sysfilesGROUP BY [filename]
if you need total sum
SELECT SUM([size] * 8)FROM sysfiles
