I know that i need to use sp_attach_single_file_db but my
question is how. Do I have to first create a database or
does the stored procedure do that with the alone. When i
used the SQL Query yzer i specified the path to the
file, the database name, but it fails to create the
database since it is asking for 'name_of_database_log file.

Can you please describe me how it is done.