I'm getting the following warning when executing usp_ReplicationMonitor within a job:
Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153)
A workaround for this issue is documented here:
However, I want to investigate the specifics before setting ANSI_WARNINGS to OFF. What is the most efficient way to find out where this is coming from?