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.
I have tried reverse engineering from
sys.server_event_notifications but it does not return a value that I can marry with
I tried also a DAC to query system views, getting more columns from that, but no joy.
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';