Joie Andrew (6/29/2016)
You could also modify the previous query to use sys.master_files. That will prevent you from having to loop through each database and you may not need a temp table either.
Tried that, doesn't work.
From BOL:
Returns the specified file name property value when a file name in the current database and a property name are specified. Returns NULL for files that are not in the current database