Howto get the physical location of Database?

[ad]

I am use a Database name "myBase" of SqlExpress 2005 as DataBase.

How can I get the physical location of "myBase"

 

[Nicholas Paldino [.NET/C# MVP]]

ad,

What do you mean by the physical location? Do you mean the files that
the information in the database is stored in, or something else?

 

[Guest]

ad,
If what you mean is the physical location of the SQLExpress MDF database
file,
you can use the following T-SQL:

use master
select filename from sysdatabases
Where name = 'MyBase'


--Peter