All geek questions in one place

What is the autocomplete option when creating a new database in SQL Server 2008?

What is the Autocomplete option when creating a new database in SQL Server 2008?

EDIT : and how do you decide whether to enable or disable it?

+3
source share
3 answers

From MSDN:

If True, the database is closed and its resources are freed when the user connection does not access the database. If False (default), the server keeps the database open and ready, regardless of user activity.

: , , . , , .

+3

,

, (, Dev/QA)

+1

Set Auto Close to false if you are using database mirroring in SQL Server 2008.

0
source

Source: https://habr.com/ru/post/1705743/

More articles:


All Articles