Database Sizes and Truncate Scripts

gistfile1.sql

select
	sd.dbid as DatabaseID,
	sd.[name] as DatabaseName,
	sd.crdate as CreationDate,
	saf.[name] as DatabaseFile,
	saf.[filename] as DatabaseFileLocation,
	(saf.[size] * 8 / 1024) as [Size],
	'USE MASTER BACKUP LOG ' + sd.[name] + ' WITH TRUNCATE_ONLY
	GO USE ' + sd.[name] + ' DBCC SHRINKFILE(' + saf.[name] + ',100)
	GO' as TruncateLog_Sql2008,
	'USE ' + sd.[name] + ' ' +
	'GO' + ' ' +
	'DBCC SHRINKFILE (' + sd.[name] + ')' as TruncateLog_Sql2012
from 
	master..sysdatabases sd
inner join 
	master..sysaltfiles saf on sd.dbid = saf.dbid
order by Size desc