ATTACH & DETACH DATABASE SQL SERVER 2000
A. DETACH DATABASE
1. Open “Enterprise Manager”.
Choose “IT102 > Databases > Northwind > All Tasks > Detach Database...”
2. If “Connections using this database” > 0, must be click “Clear” first. Then Click “OK”.
3. For check, there is no database Northwind again.
...
B. ATTACH DATABASE
1. Open “Enterprise Manager”
Choose “IT102 > Databases > All Tasks > Attach Database...”
2. Click “...”
...
For check the capture step by step, please follow the free download link below :Guide for Attach & Detach Database SQL Server 2000