SELECT name, is_auto_close_on FROM sys.databases : sys.databases « System Tables Views « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Tables Views
3. sys.databases

3> USE master
4> GO
Changed database context to 'master'.
1>
2> SELECT name, is_auto_close_on
3> FROM sys.databases
4> GO
name                                                                                                                             is_auto_close_on
-------------------------------------------------------------------------------------------------------------------------------- ----------------
master                                                                                                                                          0
tempdb                                                                                                                                          0
model                                                                                                                                           0
msdb                                                                                                                                            0
ClubRoster                                                                                                                                      1

(5 rows affected)
1>