Wednesday, December 21, 2016

[Event Notifications] Changing the owner of the endpoint

So the guy who set up Event Notifications, which you now love and adore, left.  And it turns out he set it up as his user on all the boxes, so it stopped working and now you need to change the owner of the Endpoints.  How?  Simple:




--http://akawn.com/blog/2014/06/identify-and-change-a-sql-server-endpoint-owner/

USE master;
SELECT
 SUSER_NAME(principal_id) AS endpoint_owner
,name AS endpoint_name
FROM sys.endpoints;

/*
USE master;
ALTER AUTHORIZATION ON ENDPOINT::ENAudit_Endpoint TO sa;

*/

No comments: