Today I was doing some test cases around model database,and was querying some of the tables.I just missed to close that session and was creating a new database.
Straight away I was hit by this error
We all know that a new database inherit the model structure,however I was not aware that an exclusive lock is required for the model.
I was pretty sure that consistency is the major factor which is behind this design behavior and it was confirmed after my discussion with #sqlhelp experts.
I was able to find a connect ID too for this behavior,and Microsoft has confirmed the exact reason for this –
The ID was closed with ‘By Design’ reason.
Thanks for reading.