model database Archives - SQLServerGeeks

SQL Server 2016 – Model database default settings

March 21, 2016March 21, 2016 - by Prince Rastogi - Leave a Comment

Hi Friends, Many improvements and new features are there in the SQL Server 2016. One of that change is about the model database default settings in SQL Server 2016. We know …

SQL Server

SQL Server Exclusive Lock on Database ‘model’

September 12, 2011November 13, 2014 - by Rakesh Mishra - 3 Comments.

model database is one of the sytem databases that act as a template database for creating new database, also the size of new database should be greater or equal to model …