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)
 database attach with MSDE

Author  Topic 

dasr25
Starting Member

2 Posts

Posted - 2005-11-16 : 07:39:41
How do attach database with MSDE 2000?

Vivaldi
Constraint Violating Yak Guru

298 Posts

Posted - 2005-11-16 : 07:59:40
Well,
Assuming you can do an attach in msde (never worked with it)
sql:
sp_attach_db @dbname = 'dbname'
, @filename1 = 'filename_1'

or if you have enterprise manager, open it up the db and right click on Databases, its right there.

________________________________________________

SQL = Serious Quaffing of Liquor
Go to Top of Page
   

- Advertisement -