InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 18:31:59 GMT20http://www.sqlservercentral.com/Forums/Topic1367063-1281-1.aspxok fair enough thanksWed, 03 Oct 2012 11:34:10 GMTKwisatz78http://www.sqlservercentral.com/Forums/Topic1367063-1281-1.aspxFirst off, I do not have any experience with WMIEventProviderNotifications, but I have worked a lot with Service Broker, so I may be totally off, but I think I can still answer this question for you. If I read [url=http://msdn.microsoft.com/en-us/library/ms181893.aspx]this msdn article[/url] correctly, you are not supposed to read this queue yourself. The WMI provider (which is, according to the article, implemented as a SQL Agent job) reads the items from this queue. The WMI provider seems to provide an API so that WMI-capable clients can query SQL server properties and be notified of any changes therein. Service broker seems to be involved only internally to implement this WMI provider.Wed, 03 Oct 2012 06:08:31 GMTR.P.Rozemahttp://www.sqlservercentral.com/Forums/Topic1367063-1281-1.aspxHi allBeing new to Service broker I am just trying to understand a couple of points. I am using WMI to automatically create an event notification by creating an alert.One thing I don't understand is when the notification is sent to the queue I have seen it disappear automatically. What is doing this as I thought you had to set an activation of some sort, is this just a built in SQL thing?ThanksTue, 02 Oct 2012 08:06:58 GMTKwisatz78