Use Of Select Statement In RAISERROR

Hi All,
I need to raise an error in the Application Event log based on a condition. The condition is, if a query returns any rows, an error has to be logged. For that this is what I am doing:




Code Snippet
If exists()
RAISERROR ('There are agents that have not hearbeated within the last 15-30 mins', 16, 1) WITH LOG




Now, in addition to the message in the RAISERROR, I would also want to display the results of that query in the If Exists block. How can I do that? If this is not clear, below is something which I want to do. Is this or anything similar possible?




Code Snippet
If exists(<Select * from table>)
RAISERROR ('There are agents that have not hearbeated within the last 15-30 mins', 16, 1, Select ServerName from table) WITH LOG





Thanks a lot in advance,

Manoj Deshpande.