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?

  • June 18, 2009 at 12:45 am

    #1011456

    DNA (6/18/2009)

    In SQL 2005, use the following: select * from sys.master_files

    And in sql server 2000 how to list all the sysfiles

    Tanx 😀