Use sp_attach_db in Query Analyzer rather than using Enterprise Manager;
EXEC sp_detach_db 'myDB'
go
EXEC sp_attach_db 'myDB'
,'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
,'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'
go