Get a list of database names and file locations

• lulu_lutz

  SSCrazy

  Points: 2155

  More actions

  April 13, 2011 at 8:48 am

  #74354

  I need to obtain a list of database names and their file locations in sql 2000. Any suggestions?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 13, 2011 at 2:10 pm

  #1311313

  select name, filename from master.dbo.sysdatabases

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  April 13, 2011 at 2:27 pm

  #1311324

  Get Server Database File Information

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  April 13, 2011 at 4:16 pm

  #1311370

  join sysdatabases to sysaltfiles on dbid (in master database)

  ---------------------------------------------------------------------