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.
| Author |
Topic |
|
damica
Starting Member
3 Posts |
 Posted - 2006-12-02 : 09:48:44
|
| HelloI 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 AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
Attach Database to MSDE