Monday, May 20, 2013

[SQL 2012] Alerts vs Event Notifications vs Extended Events

[SQL 2012] Alerts vs Event Notifications vs Extended Events

Alerts vs Event Notifications vs Extended Events

Posted: 19 May 2013 06:50 PM PDT

Hi All,I have an interesting integration scenario as follows ...1. An (awful) 3rd part app has it own code to execute backs and restores which the users can execute2. I need to recognise when SQLS a) [u]starts a restore[/u] so I can execute a [i]prep [/i]sproc , and, b) [u]completes a restore[/u] so I can execute [i]finalise [/i]sproc Whats the best way to do this SQL Server 2012?Have I got the best approach? e.g. is a "restore complete" event best or would a "DB Online" event be better?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog