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...

These system procedures are helpful, too (sp_helpsrvrole and sp_helpsrvrolemember).

Another option would be to use : exec msdb..sp_help_job @execution_status = 1. The information is a bit verbose and does not give you the current job step.

Thanks for the script! Might want to adapt it to use the sp_MSForeachDB for simplicity. Thanks again!