Get Auto-close And Auto-shrink Status SQL Server

Auto-close and auto-shrink should be False

Below is the query to find the options set in your databases.

SELECT [name] AS DatabaseName
, CONVERT(varchar(10),DATABASEPROPERTYEX([Name] , 'IsAutoClose')) AS AutoClose
, CONVERT(varchar(10),DATABASEPROPERTYEX([Name] , 'IsAutoShrink')) AS AutoShrink
FROM master.dbo.sysdatabases

Was this article helpful?

mood_bad Dislike 0
mood Like 0
visibility Views: 7955

Need more information or have a question ?