|
Hello! Is it possible to capture this event using the "Extended Events" feature:? I would like to track who has added the signature to the stored procedure and which procedure was affected. Thanks!
(comments are locked)
|
|
On further research, I dare to say it is not possible ;). Reasons being it is not visible in SQL 2008 R2 XE configurable events. Secondly, this seems to fall in the Security Auditing. And according to Mike Wachal from the Extended Events team at Microsoft
Although he was talking about SQL 2012, but it gives clear indication that it is something to be taken care of through SQL Audit. For that I created the following SQLAudit And guess what it gives me what is desired (which BTW also is meeting regulatory compliance requirements ;)) But if you cannot use SQL Audit, then I guess you are left with two choices i.e. SQL Trace and DDL TRIGGERS Thanks Usman! This is a great research on this topic! Unfortunately I cannot use SQL Audits, this feature requires SQL Server Enterprise Edition :( DDL Triggers do not cover this scope: As far as I can tell there's no trigger scope like ADD_SIGNATURE... :( The last resort will be SQL Trace, but I'm afraid it could harm performance, because I will have to monitor SQL:BatchCompleted-events. Anyway you've answered my question - I appreciate it a lot! :)
Aug 13 '12 at 08:00 AM
eghetto
@eghetto Of-course the same can be achieved with DDL triggers ;) The related DDL events chain is
Aug 15 '12 at 10:36 AM
Usman Butt
@usman-butt: +1! Right - I've overlooked that. Thanks!
Aug 15 '12 at 10:58 AM
eghetto
(comments are locked)
|

