You are in Oracle forum mate.

To find the location, please run the following query

select filename from dbo.sysfiles

Raman
-----Original Message-----
From: Ravi Kumar
[mailto:oracledba-ezmlmshield-x27872994.[Email address protected]
Sent: 30 October 2007 13:00
To: LazyDBA Discussion
Subject: RE: physical location of Datafiles and logfiles Using SQL
SERVER 2000/2005

Hi Andrews,

I AM ASKING IN SQL SERVER 2000/2005 NOT IN ORACLE 9I..........


Thanks
Ravi



-----Original Message-----
From: Andrews Jain [mailto:[Email address protected]
Sent: Tuesday, October 30, 2007 8:51 AM
To: Ravi Kumar
Subject: RE: physical location of Datafiles and logfiles Using SQL
SERVER 2000/2005

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


In oracle it is V$logfile and dba_data_files.

Regards

Jain Andrews

-----Original Message-----
From: Ravi Kumar
[Email address protected]
Sent: Tuesday, October 30, 2007 6:14 PM
To: LazyDBA Discussion
Subject: physical location of Datafiles and logfiles Using SQL SERVER
2000/2005

Hi Experts





Could you please tell me Command to find the physical location of
Datafiles and logfiles Using SQL SERVER 2000/2005?





Thanks

Ravi









---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





______________________________________________________________________
This e-mail has been scanned by Spam Manager Email Service, using
Skeptic(tm) technology powered by MessageLabs.
______________________________________________________________________


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






Oracle LazyDBA home page