Complete a Server Assessment – Database Auto Settings

Below you will find the code to find that auto settings for each database. For example, Auto Update Statistics.  Simply select the text and copy to the Clipboard.

SELECT * FROM sys.databases

This code was written using the Microsoft SQL Server documentation.  If you find that this code was copied from else where, please let me know so I can give proper credit.