>I need a script which will provide me the same layout that we obtain when we go in Database\Properties\Files. This is where we see the location of the .mdf, all the .ndf, if more than one, and the .ldf. I thought that would be nice to have, as on a particular server, this would save a lot of time for several persons to have to go in SSMS to get that. Is there anyone who already built this script who would like to share it or some of it, or ideas behind that?
SELECT * FROM sys.master_files
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.