List all databases and their files on MS SQL

By Tom Lasswell · September 9, 2007 · 1 min read

Originally published on TechColumnist.

A quick way to check and see all databases for your MS SQL server is to run the following command using the Query Analyzer on the Master database:

sql

select name, filename from sysdatabases