Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to list datafiles of sqlserver including path also using SMO? RE: How to list datafiles of sqlserver including path also using SMO?
DNA_DBA
SSCrazy Eights
Points: 9107
More actions
June 18, 2009 at 12:17 am
#1011444
In SQL 2005, use the following: select * from sys.master_files