While creating a Database an Error 1807 occurred as you can see the following snapshot.
Basically the create database failed due to an exclusive lock cannot be obtained on "Model" Database.
|Error 1807 - Database Creation Failed|
Run the below set of queries to find out were exactly is Model Database is on use:
IF EXISTS(SELECT request_session_id FROM sys.dm_tran_locks
WHERE resource_database_id = DB_ID('Model'))
PRINT 'Model Database being used by some other session'
PRINT 'Model Database not used by other session'
SELECT request_session_id FROM sys.dm_tran_locks
WHERE resource_database_id = DB_ID('Model')
Kill the SPID and re-run the create database syntax. This time you will create a Database without any error.
Check out the error here while executing the Extended Stored Procedure.
Keep Learning and Enjoy Learning!!!