where the database is located?
-
[No Message]
-
[No Message]
Hi What is your question?? it is blank here.
Harini
-
[No Message]
Which database? I'm assuming you mean SQL Server
select name, filename from sysfiles
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website
-
Hi What is your question?? it is blank here.
Harini
Harini Krishnaswamy wrote:
What is your question??
Read the subject line
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website
-
Which database? I'm assuming you mean SQL Server
select name, filename from sysfiles
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website
I assume you are asking for your database MDF file location , Under default installation settings, its in C:\Program Files\Microsoft SQL Server\MS SQL 1.0*\Data * dont remember it exactly Unless you change your installation folder, files are placed here by default (no matter if SQL 2000 and 2005 are both installed on your machine).
-
I assume you are asking for your database MDF file location , Under default installation settings, its in C:\Program Files\Microsoft SQL Server\MS SQL 1.0*\Data * dont remember it exactly Unless you change your installation folder, files are placed here by default (no matter if SQL 2000 and 2005 are both installed on your machine).
kaliem wrote:
I assume you are asking for your database MDF file location
You appear to have replied to the wrong person. I never asked the question. I answered it. Also, it is very easy to change the location of a database so relying on default folders is unwise. This is why my answer showed how to retrieve the location of the database files.
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website
-
kaliem wrote:
I assume you are asking for your database MDF file location
You appear to have replied to the wrong person. I never asked the question. I answered it. Also, it is very easy to change the location of a database so relying on default folders is unwise. This is why my answer showed how to retrieve the location of the database files.
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website
-
I assume any reply here would count a reply to this thread and anyone can view it. Sorry for any confusions. Yeah, relying on default folders is not good. Because of nature of that query, I wanted be more specific. Chill out :)
kaliem wrote:
I assume any reply here would count a reply to this thread and anyone can view it. Sorry for any confusions.
Yes, anyone can view it. However, this is a properly threaded forum so you have to reply to the appropriate person or it appears in the wrong place in the thread.
kaliem wrote:
Because of nature of that query, I wanted be more specific.
:confused:
Upcoming events: * Edinburgh: Web Security Conference Day for Windows Developers (12th April) * Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects My website