alter database HOD201210 set offline;
sp_detach_db N'HOD201210'
CREATE DATABASE HOD201210
ON(NAME='HOD201210', FILENAME='J:\OptionDB\HOD201210.mdf')
LOG ON(NAME='HOD201210_log', FILENAME='J:\OptionDB\HOD201210_log.ldf')
FOR ATTACH WITH ENABLE_BROKER;
I'm not sure that a simple drop of the DB would help here (guess not), hence used offline/detach/attach as with the GUI.