SELECT TOP 50
	CONVERT(datetime, LEFT(vchMsg, 23), 121) as MsgDate
	, SUBSTRING(vchMsg, 24, 10) as MsgSource
	, SUBSTRING(vchMsg, 33, 800) as MsgText
FROM #Tmp 
WHERE vchMsg NOT LIKE '%Log backed up%'
	AND vchMsg NOT LIKE '%.TRN%'
	AND vchMsg NOT LIKE '%Database backed up%'
	AND vchMsg NOT LIKE '%.BAK%'
	AND vchMsg NOT LIKE '%Run the RECONFIGURE%'
	AND vchMsg NOT LIKE '%Copyright (c)%' 
	AND LTRIM(RTRIM(LEFT(vchMsg, 1))) <> CHAR(9)
	AND ID = 0
ORDER BY 
	CONVERT(datetime, LEFT(vchMsg, 23), 121) DESC

Good stuff.  To para #3 I would add "and unscheduled jobs." 

I've been burned by someone else either removing or disabling the schedule of a regularly-scheduled job.  At first glance you say "it's still enabled, why didn't it run?"  There's no easy way to check if the schedule was deleted, but it is easy to see if the schedule is disabled.

I am going to add some of these into my daily reports.  And yes, I do have co-workers that slip in new sysadmin users!  At least this way I'll know it right away.

Any good scripts for monitoring replication status?

Regards,
Scott