I'm trying to delete a user from our MS SQL Server 2008 (yeah, I know) database server. The user in question has left the organization and is no longer in Active Directory, but apparently his name is still all over the place.
I've removed him from every database, and now I'm trying to delete him in SSMS in Object Explorer via <database name>/Security/Logins. It's giving me the following error:
The server principal is set as the execution context of a trigger or event notification and cannot be dropped. (Microsoft SQL Server, Error: 15186)
I've removed him everywhere I could find him - jobs, etc. Anyone have any other ways to find what setting he might be in, still? I've tried a couple of queries from TechNet and such (example: https://social.technet.microsoft.com/Forums/en-US/3a337af8-cc60-4c66-a475-bd0965576545/the-database-principal-is-set-as-the-execution-context-of-one-or-more-procedures-?forum=sqlsecurity
) but haven't found anything that helps yet.