InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 19:25:04 GMT20http://www.sqlservercentral.com/Forums/Topic566128-1281-1.aspxUsing event notification for logon auditing, I am getting multiple records for the same event. Is there a way to limit to a single record per event. For event type AUDIT_LOGON_FAILED, a single record is returned for an event, however, for AUDIT_LOGON, multiple records are returned per event.Please help avoiding retrieving multiple records for a single logon event. Or what other alternative exists for capturing failed login attempts. I am trying to automate the process and reporting.Any help will be appreciated.Thu, 31 Mar 2011 08:32:43 GMTbhaktapurhttp://www.sqlservercentral.com/Forums/Topic566128-1281-1.aspxApparently, Service Broker event notifications can only be scoped to a specific Queue. So change your CREATE Event Notification as follows:[code]CREATE EVENT NOTIFICATION pmQueueDisabled ON QUEUE pmNotifyQueue FOR BROKER_QUEUE_DISABLED TO SERVICE 'pmNotifyService', 'current database';[/code]Mon, 27 Oct 2008 16:08:43 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic566128-1281-1.aspxSorry, I didn't see this before....Is the comma in CREATE SERVICE a mistake or is there supposed to be another contract? (I am getting a syntax error there).Mon, 27 Oct 2008 09:42:44 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic566128-1281-1.aspxBelow is the code I am using just to try and get the notification into the queue (After that My plan was to send an email to myself with an alert of some sort.)[code]--Create a queue to receive messages.CREATE QUEUE pmNotifyQueue ;GO--Create a service on the queue that references--the event notifications contract.CREATE SERVICE pmNotifyServiceON QUEUE pmNotifyQueue([http://schemas.microsoft.com/SQL/Notifications/PostEventNotification],);GO--Create the event notification.CREATE EVENT NOTIFICATION pmQueueDisabled ON DATABASE FOR BROKER_QUEUE_DISABLED TO SERVICE 'pmNotifyService', 'current database';[/code]The error I get is :Msg 1098, Level 15, State 1, Line 2The specified event type(s) is/are not valid on the specified target object.This error is from the CREATE EVENT NOTIFICATION step.I can;t figure it out - Any Suggestions?Tue, 09 Sep 2008 06:57:27 GMTJerry Beech