September 16, 2016 at 9:10 am
Hi all
When I was trying to drop a login account, I got the below error msg:-
The server principal owns one or more event notification(s) and cannot be dropped. (Microsoft SQL Server, Error: 15141)
While doing some research I found one useful MS article:
Question is, it is asking to drop the event notification...but unable to figure out what it is doing.
Is this safe to drop it?
The event name is : CaptureSecurityEvents
Thanks.
September 16, 2016 at 12:03 pm
I would say if the login must be dropped, you have no choice but to drop the event notification prior. I looked around and there does not appear to be a way to script or save the notification that already exists. However, there are a ton of blogs with code on creating security event notifications that you could run. Hope this helps...
September 16, 2016 at 12:07 pm
can you ping me some good blog sites to create similar security notification events?
Thanks.
September 16, 2016 at 12:25 pm
My favorite and used in our prod env - https://www.brentozar.com/blitz/configure-sql-server-alerts/
General info - https://www.mssqltips.com/sqlservertip/2121/event-notifications-in-sql-server-for-tracking-changes/
Compares event notifications to extended events - https://www.sqlskills.com/blogs/jonathan/event-notifications-vs-extended-events/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply