Re: How do i find the logical file name

From: "Arnie Rowland" <arnie@xxxxxxxx>
Date: Tue, 18 Jul 2006 08:21:54 -0700

Use the system stored procedure sp_helpfile. Filename is the first field
[name], full path is the second field [filename]. One row for the data file,
and one row for the log file.

--
Arnie Rowland
"To be successful, your heart must accompany your knowledge."

<rupa.anand@xxxxxxxxx> wrote in message
news:1153232500.810152.249250@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Ihave MSDe instance running and need to find out the logical file names
for a test database

Follow-Ups:
- Re: How do i find the logical file name
  - From: rupa . anand

References:
- How do i find the logical file name
  - From: rupa . anand

Prev by Date: Re: How do i find the logical file name
Next by Date: Re: How do i find the logical file name
Previous by thread: Re: How do i find the logical file name
Next by thread: Re: How do i find the logical file name
Index(es):
- Date
- Thread

Relevant Pages

Re: Download worksstaion components
... Arnie Rowland* ... "To be successful, your heart must accompany your knowledge." ...
(microsoft.public.sqlserver.clients)
Re: User Not Listed for Permissions on a View
... Arnie Rowland* ... "To be successful, your heart must accompany your knowledge." ...
(microsoft.public.sqlserver.security)
Re: failed because the SET options have incorrect setting ARITHAB
... Arnie Rowland, YACE* ... "To be successful, your heart must accompany your knowledge." ...
(microsoft.public.sqlserver.clients)
Re: SQL server compare utility
... Arnie Rowland* ... "To be successful, your heart must accompany your knowledge." ...
(microsoft.public.sqlserver.tools)
Re: Multiple Instances
... Arnie Rowland* ... "To be successful, your heart must accompany your knowledge." ...
(microsoft.public.sqlserver.setup)