Huge help! I played with it some. I took the reference sys.tables out and removed some of the columns. Thanks!
SET NOCOUNT ON
GO
SELECT DISTINCT
SERVERPROPERTY('servername') [instance]
,DB_NAME() [database]
,QUOTENAME(OBJECT_SCHEMA_NAME(sp.object_id)) +'.'+QUOTENAME(Object_name(sp.object_id))
,ix.name [index_name]
,sp.data_compression
,sp.data_compression_desc
FROM...