sp_attach_single_file_db @dbname= 'dbname' ,@physname= 'physical_name'

but, make sure database got only one .mdf file or say datafile. This command doesnot work with multiple data files.