sp_attach_db is supposed to only work with databases that were previously detached.

You could try to create the database with the FOR ATTACH option. If that doesn't work, try recreating the entire database exactly like it was, stop SQL Server and copy the actual mdf and ldf files over the empty ones. I'm not making any promises that this will work.

-Mike