While working on query optimization project, I encountered following error.
Msg 1807, Level 16, State 3, Line 1
Could not obtain exclusive lock on database ‘model’. Retry the operation later.
Msg 1802, Level 16, State 4, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
The resolution of above problem is quick and easy.
Disconnect and Reconnect your SQL Server Management Studio’s session. Your error will go away.
Reference: Pinal Dave (http://blog.SQLAuthority.com)