Mega Code Archive

 

Categories / MSSQL / System

 

Sp_dboption Northwind, autoclose, TRUE

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)