Code to attach a Database.

exec sp_attach_db @dbname = N'DB_Cmanager',
@filename1 = N'P:\Program Files\Microsoft SQL Server\MSSQL\Data\db_cmanager.mdf',
@filename2 = N'P:\Program Files\Microsoft SQL Server\MSSQL\Data\db_cmanager_log.ldf'