Cacher is the code snippet organizer for pro developers

DECLARE @LogSpace TABLE(DatabaseName varchar(255),
					              [Log Size (MB)] float,
					              [Log Space Used (%)] float,
					              [Status] int)
INSERT INTO @LogSpace
EXECUTE('dbcc sqlperf(''LogSpace'')')

SELECT * 
  FROM @LogSpace
 --WHERE DatabaseName = ''