On a SQL Server 2008 R2 Express instance, I have the "auto Close" option set to "False" on the [model] database.
However, When I execute CREATE DATABASE [test];
, SQL Server creates the database with the auto close
option set to true
.
I checked sys.configurations
just to make sure there was nothing pending (not the case).
I also tried to change the config on [model]
to true, save, then change it back to false but I still have the same behavior.
If I create the database using the SSMS GUI (right click -> new database), it creates the database with the auto close
option set to false
How can I make CREATE DATABASE
create a database with auto close
set to false?