SQL Server/T-SQL/System/sp dboption

sp_dboption "Northwind", "autoclose", "TRUE"

   <source lang="sql">

3> sp_dboption "Northwind", "autoclose", "FALSE" 4> GO Msg 15010, Level 16, State 1, Server J\SQLEXPRESS, Procedure sp_dboption, Line 64 The database "Northwind" does not exist. Use sp_helpdb to show available databases. Available databases:

---

master tempdb model msdb ClubRoster 1> SELECT name, is_auto_close_on 2> FROM sys.databases 3> WHERE name = "Northwind" 4> GO name is_auto_close_on

---

----------------

(0 rows affected) 1> sp_dboption "Northwind", "autoclose", "TRUE" 2> GO Msg 15010, Level 16, State 1, Server J\SQLEXPRESS, Procedure sp_dboption, Line 64 The database "Northwind" does not exist. Use sp_helpdb to show available databases. Available databases:

---

master tempdb model msdb ClubRoster 1> SELECT name, is_auto_close_on 2> FROM sys.databases 3> WHERE name = "Northwind" 4> GO name is_auto_close_on

---

----------------

(0 rows affected)

</source>