Howto get the physical location of Database?

  • Thread starter Thread starter ad
  • Start date Start date
A

ad

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

How can I get the physical location of "myBase"
 
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assembler in c# 1
Basic OO question 5
Inherited event firing - compiler error 2
Fireing an inherited event compiler error 1
Sudden speed up in a C# program 3
New vs Override 3
runtime creation of an object 2
constrained generic base class AND implementing an interface 1

Back
Top