Event Notifications don't fire when raised by Activated procedure

I have an activated SP that is issuing PRINT statements.

These are raised as ErrorLog and EventLog events when using SQLProfiler

However if you attach an event notification for ERRORLOG and EVENTLOG, nothing appears in the queue. Any other ERRORLOG or EVENTLOG event caught by profiler is caught by the event notification as expected.

Please use the SQLServer feedback site to report this issue: https://connect.microsoft.com/SQLServer/Feedback

Thanks,
~ Remus

|||

Done including a repro

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=230910

Event Notifications are not in the SQL Management Studio UI?

hi. can't seem to find the event notifications in the service broker folder of Management Studio.. I can get the information from sys.event_notifications, but it seems odd that event notifications are not in the UI. Hopefully I'm looking in the wrong place?

Event notifications use Service Broker for delivery but they are not part of Service Broker. When you create a queue and a service to handle an event notification, the service will show up in the service Broker UI. Management Studio support is not completely implemented for some of the new features in SQL Server 2005 so occasionally you may find some minor gaps in the GUI coverage that require you to look up the DDL to accomplish what you need to do.

Event Notifications are not in the SQL Management Studio UI?

hi. can't seem to find the event notifications in the service broker folder of Management Studio.. I can get the information from sys.event_notifications, but it seems odd that event notifications are not in the UI. Hopefully I'm looking in the wrong place?

Event notifications use Service Broker for delivery but they are not part of Service Broker. When you create a queue and a service to handle an event notification, the service will show up in the service Broker UI. Management Studio support is not completely implemented for some of the new features in SQL Server 2005 so occasionally you may find some minor gaps in the GUI coverage that require you to look up the DDL to accomplish what you need to do.

Event Notification vs. Triggers

Hi,
Event Notifications can send a message to particular service while this can
be done exactly in a trigger. I mean the DDL/DML trigger can send required
message to a service for asynchronous processing. So what's the advantage of
using Event Notification?
Thanks,
Leila
See if this helps.
http://www.awprofessional.com/articl...&seqNum=5&rl=1
AMB
"Leila" wrote:

> Hi,
> Event Notifications can send a message to particular service while this can
> be done exactly in a trigger. I mean the DDL/DML trigger can send required
> message to a service for asynchronous processing. So what's the advantage of
> using Event Notification?
> Thanks,
> Leila
>
>

Event Notification vs. Triggers

Hi,
Event Notifications can send a message to particular service while this can
be done exactly in a trigger. I mean the DDL/DML trigger can send required
message to a service for asynchronous processing. So what's the advantage of
using Event Notification?
Thanks,
LeilaSee if this helps.
http://www.awprofessional.com/artic...4&seqNum=5&rl=1
AMB
"Leila" wrote:

> Hi,
> Event Notifications can send a message to particular service while this ca
n
> be done exactly in a trigger. I mean the DDL/DML trigger can send required
> message to a service for asynchronous processing. So what's the advantage
of
> using Event Notification?
> Thanks,
> Leila
>
>

Event Notification vs. Triggers

Hi,
Event Notifications can send a message to particular service while this can
be done exactly in a trigger. I mean the DDL/DML trigger can send required
message to a service for asynchronous processing. So what's the advantage of
using Event Notification?
Thanks,
LeilaSee if this helps.
http://www.awprofessional.com/articles/article.asp?p=327394&seqNum=5&rl=1
AMB
"Leila" wrote:
> Hi,
> Event Notifications can send a message to particular service while this can
> be done exactly in a trigger. I mean the DDL/DML trigger can send required
> message to a service for asynchronous processing. So what's the advantage of
> using Event Notification?
> Thanks,
> Leila
>
>