SQL Server Performance Forum – Threads Archive
Check for a database setting
I want to query my databases to find out if Auto Shrink is set. I know the status column in sysdatabases holds this value as a bit setting but I don’t know how can I check this value using a query. CanadaDBAselect DATABASEPROPERTY(‘master’,’IsAutoShrink’) see more in BOL about DATABASEPROPERTY Madhu
BOL states AUTOSHRINK sysdatabases value:
1 = TRUE 0 = FALSE NULL = Input not valid
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>