January 21, 2016 at 10:24 am
Hi,
How do you get an alert when there is any modification of SPs are Views without creating any triggers.
I need the details who modified and which sp modified and the change. How can we get alert through SQL Alerting system
January 21, 2016 at 11:15 am
The most effective way you can have this done from within SQL Server itself is through triggers. You can set up extended events to capture the changes... it's going to be difficult to get a response though. You'll have to have it output to a buffer and have an application monitor that buffer. It's not going to work well. Triggers will.
Now, you can use external tooling to do the work, but it's not going to be the same as setting up a trigger. I wrote an article on it.[/url]
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2016 at 2:50 pm
So triggers are the only option if you don't want have any 3rd party tools!
January 21, 2016 at 3:17 pm
ramana3327 (1/21/2016)
So triggers are the only option if you don't want have any 3rd party tools!
Well, extended events are not a third party tool. You would have to write some software to respond to events, but that's still not 3rd party.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2016 at 10:01 pm
Yes. Understood
Thank you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply