Sunday, February 26, 2012

Event Type for Object:ALTERED, Object:Created , Object:Deleted Event Class

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