Attach Database to MSDE - SQL Server Forums

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

MSDE (2000)

Attach Database to MSDE

Author

Topic

damica
Starting Member

3 Posts

Posted - 2006-12-02 : 09:48:44

Hello

I am new to sql server so please be kind.

I have created a database on my sql server at home. I now want to put the database on a machine at work that is just running MSDE so that my VB6 application can access the data. Can't seem to figure this out.
Thanks for your help.

David M. Camp

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-02 : 10:30:37

Make use of sp_attach_db proc:

EXEC sp_attach_db @dbname = N'db1', 
   @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\db1.mdf', 
   @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\db1_log.ldf'

Replace @dbname, @filename1 and @filename2 with actual name and paths.

Harsh Athalye
India.
"Nothing is Impossible"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources