Home Forums Article Discussions Article Discussions by Author Discuss content posted by anthonyszm How to output datafiles location using sp_helpdb? RE: 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