Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Import DB from mdf file

Author  Topic 

JokeVC
Starting Member

2 Posts

Posted - 2004-09-17 : 08:03:23
Hi,

I need to import a database, but i've only got the mdf file.
How can i import this database into mssql on my PC ?

Thx in advance,
Joke

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-09-17 : 08:05:49
Use the sp_attach_single_file_db stored procedure. Books Online will show you the syntax.
Go to Top of Page

JokeVC
Starting Member

2 Posts

Posted - 2004-09-17 : 08:27:06
thank you very much, it worked great :D
Go to Top of Page
   

- Advertisement -