Finding File Path of a database file (mdf)

[jstiegelmeyer]

Does anyone know of a stored procedure that I can use to determine the file path of an attached db file?

Essentially, I need to be able to use ADO in VB 6.0 to determine the path of the db file, so any stored procedure that can be used in Query Analyzer would work.

Thanks in advance,
Jamie

 

[JayKusch]

SELECT RTRIM(filename)
FROM YourDatabaseName.dbo.SysFiles
WHERE Name = 'YourDatabaseName_Data'

Thanks

J. Kusch

 

[jstiegelmeyer]

Excellent, thanks JayKusck!

In case anyone else uses this for reference, let me correct a typo ("Dat" instead of "Data&quot:

SELECT RTRIM(filename)
FROM YourDatabaseName.dbo.SysFiles
WHERE Name = 'YourDatabaseName_Dat'

Also, you can get more DB info if you use

SELECT *
FROM YourDatabaseName.dbo.SysFiles

Thanks again!

 

[MaffewW]

or
sp_helpdb 'your database name'
give you information about the specified database

Matt

Brighton, UK