Getting DATA & LOG File information of ALL
Database in SQL SERVER
This helps to get all the data and log
file information like physical path.size etc of all databases available in the server.
EXECUTE master.sys.sp_MSforeachdb 'USE [?]; EXEC sp_helpfile'
Thanks :)