Activity overview
Latest activity by Ignition
Hi, Thanks for setting a Community forum and for asking. Yes I am using SQL Monitor, specially now that we are more security conscious, I have setup an Alert following the recommendations for custom metrics for SQL Injection and then set an Alert base on the new metric. I have also setup an extended event to capture failed scripts which I've copied from a post by Kendra Little. I would like the SQL Injection Alert to start a job to capture all the failed scripts 2 minutes before and after the Alert, so as to give me a narrowed down set of data to review. Could you recommend a way that I can achieve this? One of my ideas is to create a custom metric using MS Windows Server Performance monitor base on the SQL Injection counter and then set an alert to start a predefined Task or run a script, but then maybe there is another way of doing this using the tools we are very familiar with ... Red-Gate and SSMS Thanks in advance, Ignacio / comments
Hi, Thanks for setting a Community forum and for asking.Yes I am using SQL Monitor, specially now that we are more security conscious, I have setup an Alert following the recommendations for custom...
Can SQL Monitor Alerts start a SQL job or run a SQL Script or start a Custom Metric ?
Sorry, the actual Category for this question is SQL Monitor (for some reason I can only select SQL Prompt in ADS)I've configured the recommended metrics for SQL Injection alerts. I have also confi...