Fast2Host Logo

Databases

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



Maintain peace of mind with UK based support

Email any time or call 01480 26 00 00 014 80 26 00 00