Mega Code Archive

 

Categories / MSSQL / Database

 

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>