Tuesday, June 26, 2012 3:25 PM
When using custom event_notitifications is there an method to change the principal_ID associated with all the events listed in sys.server_event_notifications. I would prefer not to drop all the existing event notifications to change the existing account tied to the event. Since catalog modifications are not allowed in SQL 2005 is there any other method available?
- Moved by amber zhang Thursday, June 28, 2012 2:59 AM (From:SQL Server Security)
Thursday, June 28, 2012 7:07 AMModerator
Using ALTER command to change the ownership of the EVENT NOTIFICATION is not supported. The only way to achieve that is dropping the event notification and recreating it with another owner.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- Marked As Answer by Iric WenModerator Wednesday, July 04, 2012 8:49 AM
Monday, July 02, 2012 2:16 PM
Thanks for the verification.