Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

SELECT name, is_auto_close_on FROM 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>