Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to output datafiles location using sp_helpdb? Expand / Collapse
Author
Message
Posted Thursday, July 01, 2010 11:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 05, 2013 9:25 AM
Points: 76, Visits: 673
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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, January 24, 2014 12:55 PM
Points: 14, Visits: 179
If you do not require the in a table just

exec sp_MSforeachdb 'exec sp_helpdb ''?'''

Post #947009
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse