Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

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:

http://support.microsoft.com/kb/304535

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?

share|improve this question
what are you replicating? is there a view in there that contains an aggregate or something similar? – swasheck Jun 25 '12 at 18:22

migrated from stackoverflow.com Jun 25 '12 at 14:59

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.