How to output datafiles location using sp

Home

How to output datafiles location using sp_helpdb?

Author

Message

Posted Thursday, July 01, 2010 11:14 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 11, 2010 11:22 PM
Points: 0, Visits: 64

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

Post #946586

Posted Thursday, July 01, 2010 11:49 PM

SSC Journeyman

Group: General Forum Members
Last Login: Saturday, June 23, 2012 12:00 AM
Points: 76, Visits: 670

In SQL 2005 and 2008 use

Select * from sys.database_files
Select * from sys.master_files

Post #946591

Posted Friday, July 02, 2010 10:56 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:43 AM
Points: 14, Visits: 173

If you do not require the in a table just

exec sp_MSforeachdb 'exec sp_helpdb ''?'''

Post #947009

Permissions