How to output datafiles location using sp_helpdb?

• anthonyszm

  SSC Rookie

  Points: 36

  More actions

  July 1, 2010 at 11:14 pm

  #220663

  Comments posted to this topic are about the item How to output datafiles location using sp_helpdb?

• ramesh-447365

  SSC Enthusiast

  Points: 124

  More actions

  July 1, 2010 at 11:49 pm

  #1188006

  In SQL 2005 and 2008 use

  Select * from sys.database_files

  Select * from sys.master_files

• Simian336

  SSC Enthusiast

  Points: 156

  More actions

  July 2, 2010 at 10:56 am

  #1188360

  If you do not require the in a table just

  exec sp_MSforeachdb 'exec sp_helpdb ''?'''

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 18, 2016 at 1:08 pm

  #1879992

  Thanks for the script.