Hi
I am trying to create a EVENT NOTIFICATION for tracking changes to existing database objects. New Database objects, DEletion of any database objects.
For this I would like to know what is the EEVEN TYPE given in CREATE NOTIFICATION syntax for the three events...
CREATE EVENT NOTIFICATION Logging_Schema_Change_Notification
ON DATABASE
FOR Object:Altered_EVENT -- This is the piece that is failing ...what is the name ?
TO SERVICE 'LoggingSchemaService', 'current database'
GO
regards
Imtiaz
Try
FOR Object_Altered
FOR Object_Created
and
FOR Object_Deleted
No comments:
Post a Comment