Listing 5: Code to Show the Size of a Sparse File

SELECT 'CurrentSize (MB)' = size_on_disk_bytes /1024
FROM sys.dm_io_virtual_file_stats (db_id('AdventureWorks_snapshot'),1)
SELECT 'MaxSize (MB)' = size
FROM AdventureWorks_snapshot.sys.database_files
WHERE file_id = 1