Hi, i set in my servers a trigger that if a database is created or deleted then send email. now everything is working fine,but when the email is sent to me i see in the sql server waits this wait BROKER_RECEIVE_WAITFOR WAITFOR(RECEIVE conversation_handle, service_contract_name, message_type_name, message_body FROM ExternalMailQueue INTO @msgs), TIMEOUT @rec_timeout how can i disable this wait.(i must say that after a minute or two this waits disappear) Thx
As per BOL: Occurs when the RECEIVE WAITFOR is waiting. This is typical if no messages are ready to be received. http://msdn2.microsoft.com/en-us/library/ms179984.aspx http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3002763&SiteID=17