I detached a database, and when i try to re-attach it i am getting error:
CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\RoadMap.mdf'. (Microsoft SQL Server, Error: 5123)
Is there a way i can delete that database and create new one instead of re-attaching it.