SQL Server/T-SQL/Database/databases

Query is_auto_close_on FROM sys.databases

   <source lang="sql">

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>

      </source>
   
  

Using system table: databases

   <source lang="sql">

1> DECLARE @DBName nvarchar(128) 2> DECLARE @TBLName nvarchar(128) 3> SET @DBName = N"Northwind" 4> SET @TBLName = N"Shippers" 5> 6> SELECT name 7> FROM sys.databases 8> WHERE name = @DBName 9> GO

      </source>