Event Notification Principal change to another ID

Question

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?

Answer 1

Hi rdelar01,

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 see this thread: http://social.msdn.microsoft.com/Forums/is/sqlsecurity/thread/f68d3832-07e4-48eb-8c28-c668f3acd8a4

TechNet Subscriber Support

If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hi Iric,

Thanks for the verification.

Ryan