ps (12/13/2008)
You can also create a dummy database with the same name as your original database, shut down sql server service and overwrite your data files with original files. Restart sql server service, It'd recover the data you had in the original database.
this is a last resort for damaged files. If your data files are ok then just attach as normal dont resort to this scenario
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉