how to finding out where SQLSERVER databases installed using SQLSMO

Question

Hi i am trying to findout the location of where SQLSERVER datafiles(mdf) logfiles(ldf) installed using SMO.

How to do this. i Need to find for both for named instance and default instance and for sqlexpress also

can any body help me inthis regard....

Thanks in advance.

Answer 1

Duplicate - see :

http://stackoverflow.com/questions/474498/sql-smo-how-to-get-path-of-database-physical-file-name

Marc