Post reply

How to list datafiles of sqlserver including path also using SMO?

  • June 17, 2009 at 11:03 pm

    #138800

    Hi

    I wat to find the exact datafile path using SMO.But when i tried it gives upto

    c:/pf/miscosoftsqlserever/../../data.

    But i need to display the exact path

    c:/pf/miscosoftsqlserever/../../data/master.mdb

    How to do this ??

    Thanks in advance.

  • June 18, 2009 at 12:01 am

    #1011435

    select * from sysfiles

    Tanx 😀

  • June 18, 2009 at 12:17 am

    #1011444

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

  • 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 😀

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply