Get Autoclose and Autoshrink Values for the Databases in Sql Server

select databasepropertyex('yourdb','isautoshrink')


You can change it with the ALTER DATABASE statement


ALTER DATABASE yourdb

SET AUTO_SHRINK OFF | ON