SQL Server Performance Forum – Threads Archive
Check for a database settingI 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. CanadaDBA
select DATABASEPROPERTY(‘master’,’IsAutoShrink’) see more in BOL about DATABASEPROPERTY Madhu
BOL states AUTOSHRINK sysdatabases value:
1 = TRUE 0 = FALSE NULL = Input not valid
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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.