Results 1 to 2 of 2

Thread: DB Drive

  1. #1
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71

    Unanswered: DB Drive

    Can you please tell me if there is any store proc that will show on which drive is the databases, if not, if anyone has a code i will a appreciate.

    Thanks in advance

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    select * from sysfiles

    wll tell you the location of the data files (and trans log files) for that database.
    Regards
    Dbabren

Posting Permissions

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