Take a look at sp_attach_db system stored procedure.

>I recently had to reinstall windows2000 server and when I reinstalled SQL Server 2000 Standard, into the default directories, where my data was residing in the data directory, all the databases showed up upon loading EM, but one database that is in the same data directory.
>
>How do I get that database to be recognized by SQLServer2K?
>
>TIA