Utility Queries–Database Files, (and Filegroups)
- by drsql
It has been a while since I last posted a utility query, and today, to avoid other work I am supposed to be doing, I decided to go ahead and work on another post. Today, I went ahead and worked on a server configuration type query. One query I find I use pretty often is the following one that lists the files in the database. In this blog I will include 3 queries. The first will deal with files and databases, and the second runs in a database to see the files and their filegroups (If there...(read more)