1> USE master
2> GO
Changed database context to 'master'.
1>
2> SELECT name, is_auto_close_on FROM sys.databases
3> GO
name is_auto_close_on
----------------------------------------------------------- ----------------
master 0
tempdb 0
model 0
msdb 0
MyDb 1
(5 rows affected)
1>
2>