Attach database in Microsoft SQL 2000

Click Start -> All Programs -> Enterprise Manager

The interface of Microsoft SQL Enterprise Manager like that

Double click Microsoft SQL Servers, double click SQL Server Group, double click Local, and double click Databases until the display like that

Right click in Database

Put your cursor in All Tasks and click Attach Database

Click button … in right of MDF File

Choose/click your MDF file database that you want attach

And then click OK

Click OK

Click Ok, if your attach success the Microsoft SQL Enterprise Manager will display your database in Database