Here's a strange one...

I have a job that sends a notification when one of the steps throws an error. The notification contains the last error inserted into an error log table:

EXEC xp_sendmail @recipients = me@mycompany.com', @dbuse = 'Bridge_Metering', @query = 'SELECT TOP 1 error_msg FROM tbl_cdr_agent_errors', @subject = 'Retrieval Error'

Seems pretty straight forward. The problem is that the query is now returning the column nams instead of the data. I have played with * instead of a specific column, and I get all the column names.

It used to work fine, so I susoect it is patch-induced. Any one else have this problem?

TIA