Hi,
I executed the below code and it ran successfully with sql message 'Mail sent'
exec master..xp_sendmail @recipients = 'nanawarem@yahoo.co.in',
@message = @mess ,
@query = @q,
@attachments='Cases Assigned.txt',
@attach_results ='True',@width=800,
@separator='|',
@subject = @sub,
Since the recipients mailbox is full, he is not able to receive the mail.
I WANT TO KNOW IS THERE ANY CODE IN SQL TO KNOW THAT THE recipient's MAILBOX IS FULL
Thanks!