SQL Interview: 61 Effects of AUTO_CLOSE
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.
Section: Administration Level: Medium
Question:
You are reviewing database settings for a server.
You notice that one database has AUTO_CLOSE configured. Your model database does not have it enabled.
What is the most likely cause for that setting to be enabled, and what effect does enabling it have?
2025-07-07