SQL Server Performance

Check for a database setting

Discussion in 'SQL Server 2005 General DBA Questions' started by CanadaDBA, Feb 14, 2007.

  1. CanadaDBA New Member

    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.

  2. madhuottapalam New Member

    select DATABASEPROPERTY('master','IsAutoShrink')

    see more in BOL about DATABASEPROPERTY

  3. satya Moderator

    BOL states AUTOSHRINK sysdatabases value:
    1 = TRUE

    0 = FALSE

    NULL = Input not valid

    Satya SKJ
    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.

Share This Page