DataFile and Log File

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Rogers" <naissani@xxxxxxxxxxx>
Date: Fri, 27 Apr 2007 16:58:36 -0400

I want to know the datafile and log file for the given input parameter. I am
basically creating function and the input parameter would be database name
and that will return me DataFile and the LogFile.

Can anybody tell me which query I have to used in the function. I have to
used to get the DataFile and LogFile

.

Follow-Ups:
- Re: DataFile and Log File
  - From: Andrew J. Kelly

Prev by Date: SQL Server 2005 Standard Edition
Next by Date: Re: DataFile and Log File
Previous by thread: SQL Server 2005 Standard Edition
Next by thread: Re: DataFile and Log File
Index(es):
- Date
- Thread

Relevant Pages

Re: DataFile and Log File
... am basically creating function and the input parameter would be database ... name and that will return me DataFile and the LogFile. ...
(microsoft.public.sqlserver.clients)
Re: DataFile and Log File
... Andrew J. Kelly SQL MVP ... am basically creating function and the input parameter would be database ... name and that will return me DataFile and the LogFile. ...
(microsoft.public.sqlserver.clients)
Re: create database fatal error
... CREATE DATABASE statement i run the catalog.sql and catproc.sql scripts. ... sysaux datafile ... This clause is optional, as is the DATAFILE clause of the ...
(comp.databases.oracle.server)
Re: Oracle 8.1.7 rollback segment help
... > Might you access to oracle and delete only the datafile or I must ... Oracle knows nothing of this loss, ... "I have a problem with my Oracle database 8.1.7. ... rollback segments. ...
(comp.databases.oracle.server)
Re: Oracle 9i - database cannot open due to UNDOTBS01
... I am new to using Oracle and I am using 9.2.0.7. ... and spfile of my database. ... not backup was the UNDO. ... alter database datafile 'UNDOTBS01.DBF' OFFLINE DROP; ...
(comp.databases.oracle.server)