Query is_auto_close_on FROM sys.databases : databases « Database « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Database
3. databases

Query is_auto_close_on FROM sys.databases

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>
           
       

Related examples in the same category