Generate Script for Event Notification

0 votes

1 answer

731 views

                          I need to migrate my Event Notifications from current server to another one. I would like to generate that code, but I couldn't find an way to do that. 

**Try 1**

I have tried reverse engineering from sys.server_event_notifications but it does not return a value that I can marry with sys.event_notification_event_typeid. 

**Try 2**

I tried also a DAC to query system views, getting more columns from that, but no joy.

**Try 3**

Tried sp_helptext the objects, but it can't be found.

**EXPECTED OUTPUT** (for one event)

    CREATE EVENT NOTIFICATION [CaptureDeadlocks]
    ON SERVER
    WITH FAN_IN
    FOR DEADLOCK_GRAPH
    TO SERVICE N'DeadlockService', N'current database';

Any ideas?

Asked by Rafael Dontal Gonçalez (1 rep)

Mar 15, 2018, 12:34 PM
Last activity: Mar 8, 2025, 02:01 PM

Generate Script for Event Notification

Related Questions