Written by: Alex Petrovsky
8/11/2008 10:23 AM

Yesterday I worked on Event Notification and found new events in SQL Server 2008:

DLL (Database and Server)
CREATE_ASYMMETRIC_KEY, ALTER_ASYMMETRIC_KEY, DROP_ASYMMETRIC_KEY
ALTER_AUTHORIZATION
ADD_COUNTER_SIGNATURE, DROP_COUNTER_SIGNATURE
CREATE_CREDENTIAL, ALTER_CREDENTIAL, DROP_CREDENTIAL
CREATE_DEFAULT, DROP_DEFAULT, BIND_DEFAULT, UNBIND_DEFAULT
CREATE_EXTENDED_PROPERTY, ALTER_EXTENDED_PROPERTY, DROP_EXTENDED_PROPERTY
CREATE_FULLTEXT_CATALOG, ALTER_FULLTEXT_CATALOG, DROP_FULLTEXT_CATALOG
CREATE_FULLTEXT_INDEX, ALTER_FULLTEXT_INDEX, DROP_FULLTEXT_INDEX
CREATE_PLAN_GUIDE, ALTER_PLAN_GUIDE, DROP_PLAN_GUIDE
CREATE_SPATIAL_INDEX
RENAME
CREATE_RULE, DROP_RULE, BIND_RULE, UNBIND_RULE
CREATE_SCHEMA, ALTER_SCHEMA, DROP_SCHEMA
ALTER_SERVICE_MASTER_KEY, BACKUP_SERVICE_MASTER_KEY, RESTORE_SERVICE_MASTER_KEY
ADD_SIGNATURE, DROP_SIGNATURE
CREATE_SYMMETRIC_KEY, ALTER_SYMMETRIC_KEY, DROP_SYMMETRIC_KEY

DLL (Server)
CREATE_EXTENDED_PROCEDURE, DROP_EXTENDED_PROCEDURE
ALTER_INSTANCE
CREATE_LINKED_SERVER, ALTER_LINKED_SERVER, DROP_LINKED_SERVER
CREATE_LINKED_SERVER_LOGIN, DROP_LINKED_SERVER_LOGIN
CREATE_MESSAGE, ALTER_MESSAGE, DROP_MESSAGE
CREATE_REMOTE_SERVER, ALTER_REMOTE_SERVER, DROP_REMOTE_SERVER

New events for Event Notification Application Wizard are supposed to be in next version. But there are some more features we are planning to add in this wizard.

Trackback Print

Location: Blogs Quest Service Broker Admin