Complete a Server Assessment – Database Snapshot

Below you will find the code to find the database snapshots that exist on the server.  Simply select the text and copy to the Clipboard.

SELECT
d1.Name
, d1.compatibility_Level
, d1.create_date
, DB_Name(d1.source_database_id) AS ‘SourceDBName’
FROM sys.databases d1
WHERE d1.source_database_id IS NOT NULL

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.