Sunday, February 26, 2012

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.

No comments:

Post a Comment