Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Question Unanswered: Howto: List database files from databases?

    Hi,

    I'm trying to list all database locations with SQL command, but getting lost here

    So, anyone any idea how to get databasefile locations from server?
    All I need is like: 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf' and others.

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    SELECT * FROM SYSFILES will do?

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    Thanks, that was the one :|

  4. #4
    Join Date
    Jan 2004
    Posts
    2
    You might want try select * from sysaltfiles

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •