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 list datafiles of sqlserver including path also using SMO? Expand / Collapse
Author
Message
Posted Wednesday, June 17, 2009 11:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 25, 2009 12:20 AM
Points: 6, Visits: 37
Hi

I wat to find the exact datafile path using SMO.But when i tried it gives upto

c:/pf/miscosoftsqlserever/../../data.

But i need to display the exact path

c:/pf/miscosoftsqlserever/../../data/master.mdb

How to do this ??

Thanks in advance.
Post #737158
Posted Thursday, June 18, 2009 12:01 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 28, 2013 8:50 AM
Points: 1,607, Visits: 1,039
select * from sysfiles

Tanx
Post #737170
Posted Thursday, June 18, 2009 12:17 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:01 AM
Points: 2,704, Visits: 2,311
In SQL 2005, use the following: select * from sys.master_files
Post #737182
Posted Thursday, June 18, 2009 12:45 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 28, 2013 8:50 AM
Points: 1,607, Visits: 1,039
DNA (6/18/2009)
In SQL 2005, use the following: select * from sys.master_files


And in sql server 2000 how to list all the sysfiles



Tanx
Post #737197
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse