Browsing the archives for the sys.databases tag

List of Databases

Back in April I posted a query that shows instance information.  This post is the next level down in the hierarchy that I collect on my database platforms each week…  The databases in an instance. This query is certainly one of the more straight forward queries to capture database data.  It probably doesn’t really need […]


Database Properties

A couple of weeks ago a colleague asked me how to determine the recovery model of a database using T-SQL.  In other words, not using SSMS.  For the purpose of this post I’m going to show how to determine the recovery model for a database using SSMS, and then answer the presented question. The following […]