Back to Browse

SQL Database Auto close property || Do we set it to ON/OFF ?? || Ms SQL

2.6K views
Feb 7, 2022
7:47

When AUTO CLOSE option is turned ON (TRUE) for a database; SQL Server will close the user database after its use. The database is shut down cleanly and its resources are freed after the last user exits. The database will be turned ON next time when someone wants to access the database. For example, this re-open behavior occurs when a user issues a USE database_name statement. When AUTO CLOSE option is turned OFF (FALSE) for a database; The database remains open after the last user exits.

Download

1 formats

Video Formats

360pmp412.9 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

SQL Database Auto close property || Do we set it to ON/OFF ?? || Ms SQL | NatokHD