|
|
| microhead 2005-09-08, 8:23 pm |
| Hi there,
Is there any way to open the .mdf file? Is it the data from the database?
Thanks in advance
| |
| Jens Süßmeyer 2005-09-08, 8:23 pm |
| Is it the data from the database?
-Yes.
Is there any way to open the .mdf file?
-You can open the mdf file with attaching it to the database. Have a look on
sp_attachdb in the BOL
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
"microhead" < microhead@discussion
s.microsoft.com> wrote in message
news:64D73090-E65E-494F-BB2B- FBFBC1E28AC0@microso
ft.com...
> Hi there,
>
> Is there any way to open the .mdf file? Is it the data from the database?
>
> Thanks in advance
| |
| John Bell 2005-09-08, 8:23 pm |
| Hi
If the file was detached properly then it can be re-attached with
sp_attach_single_fil
e_db
John
"microhead" < microhead@discussion
s.microsoft.com> wrote in message
news:64D73090-E65E-494F-BB2B- FBFBC1E28AC0@microso
ft.com...
> Hi there,
>
> Is there any way to open the .mdf file? Is it the data from the database?
>
> Thanks in advance
| |
| microhead 2005-09-08, 8:23 pm |
| tks Jens but where and what is sp_attachdb and BOL???
"Jens Süßmeyer" wrote:
> Is it the data from the database?
> -Yes.
>
> Is there any way to open the .mdf file?
> -You can open the mdf file with attaching it to the database. Have a look on
> sp_attachdb in the BOL
>
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>
>
> "microhead" < microhead@discussion
s.microsoft.com> wrote in message
> news:64D73090-E65E-494F-BB2B- FBFBC1E28AC0@microso
ft.com...
>
>
>
| |
| microhead 2005-09-08, 8:23 pm |
| tks John for the reply but I am not running SQL in my machine and I don't
know is any other way to open that file or convert it to other formats!?
tks again.
"John Bell" wrote:
> Hi
>
> If the file was detached properly then it can be re-attached with
> sp_attach_single_fil
e_db
>
> John
>
> "microhead" < microhead@discussion
s.microsoft.com> wrote in message
> news:64D73090-E65E-494F-BB2B- FBFBC1E28AC0@microso
ft.com...
>
>
>
| |
| Tom Moreau 2005-09-08, 8:23 pm |
| BOL = Books Online
sp_attachdb = a system stored procedure that you can use to attach the
database
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"microhead" < microhead@discussion
s.microsoft.com> wrote in message
news:00F1A5D1-29C7-4F75-AF69- C38675BFE63B@microso
ft.com...
tks Jens but where and what is sp_attachdb and BOL???
"Jens Süßmeyer" wrote:
> Is it the data from the database?
> -Yes.
>
> Is there any way to open the .mdf file?
> -You can open the mdf file with attaching it to the database. Have a look
> on
> sp_attachdb in the BOL
>
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>
>
> "microhead" < microhead@discussion
s.microsoft.com> wrote in message
> news:64D73090-E65E-494F-BB2B- FBFBC1E28AC0@microso
ft.com...
>
>
>
| |
| microhead 2005-09-08, 8:23 pm |
|
tks Tommy!)
"Tom Moreau" wrote:
> BOL = Books Online
> sp_attachdb = a system stored procedure that you can use to attach the
> database
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "microhead" < microhead@discussion
s.microsoft.com> wrote in message
> news:00F1A5D1-29C7-4F75-AF69- C38675BFE63B@microso
ft.com...
> tks Jens but where and what is sp_attachdb and BOL???
>
> "Jens Süßmeyer" wrote:
>
>
>
| |
| Hari Prasad 2005-09-08, 8:23 pm |
| Hi,
MDF file can be attached as a database and can be viewable only using SQL
Server. If you dont have a SQL Server you
can not open or read the file.
Easy way is:-
1. Install a SQL Server
2. Open Query analyzer
3. Attach the database using sp_attach_db (See the sql server books online)
4. Now use the database name and access using TSQL commands.
Thanks
Hari
SQL Server MVP
"microhead" < microhead@discussion
s.microsoft.com> wrote in message
news:3591FB30-A02E-4A9E-8F63- 8EEC6419B689@microso
ft.com...[color=darkred]
> tks John for the reply but I am not running SQL in my machine and I don't
> know is any other way to open that file or convert it to other formats!?
>
> tks again.
>
> "John Bell" wrote:
>
| |
| John Bell 2005-09-09, 3:23 am |
| Hi
Without SQL Server it is effectively meaningless. If you have a server that
it can be attached to use that or if you have a product that entitles you to
use MDSE then that may be an option (file should be < 2GB) see
http://www.microsoft.com/technet/se...n/msdeapps.mspx for
possible products. Failing that the developer edition is $50
John
"microhead" < microhead@discussion
s.microsoft.com> wrote in message
news:3591FB30-A02E-4A9E-8F63- 8EEC6419B689@microso
ft.com...[color=darkred]
> tks John for the reply but I am not running SQL in my machine and I don't
> know is any other way to open that file or convert it to other formats!?
>
> tks again.
>
> "John Bell" wrote:
>
| |
| microhead 2005-09-09, 8:23 pm |
|
Tks Hari! Very appreciated:)
"Hari Prasad" wrote:
> Hi,
>
> MDF file can be attached as a database and can be viewable only using SQL
> Server. If you dont have a SQL Server you
> can not open or read the file.
>
> Easy way is:-
>
> 1. Install a SQL Server
> 2. Open Query analyzer
> 3. Attach the database using sp_attach_db (See the sql server books online)
> 4. Now use the database name and access using TSQL commands.
>
>
> Thanks
> Hari
> SQL Server MVP
>
> "microhead" < microhead@discussion
s.microsoft.com> wrote in message
> news:3591FB30-A02E-4A9E-8F63- 8EEC6419B689@microso
ft.com...
>
>
>
| |
| microhead 2005-09-09, 8:23 pm |
|
Tk you, John!
"John Bell" wrote:
> Hi
>
> Without SQL Server it is effectively meaningless. If you have a server that
> it can be attached to use that or if you have a product that entitles you to
> use MDSE then that may be an option (file should be < 2GB) see
> http://www.microsoft.com/technet/se...n/msdeapps.mspx for
> possible products. Failing that the developer edition is $50
>
> John
>
> "microhead" < microhead@discussion
s.microsoft.com> wrote in message
> news:3591FB30-A02E-4A9E-8F63- 8EEC6419B689@microso
ft.com...
>
>
>
|
|
|
|