sysmail_event_log last_mod_user has a disabled login

  • Hello experts,

    We routinely disable sa after a SQL install. However, while troubleshooting a database mail issue (test mail not received), I saw that the sysmail_event_log entries have last_mod_user of sa for some rows.

    How can that be if the login is disabled? How can I change it so that sa is not used here?

    Thanks for any help.

    -- webrunner

    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Hi,

    the SA login is disabled, but the user is still able to work with the sql server.

    The sa login maybe the owner of the jobs, or the owner of some databases. Only the login is disabled.

    Kind regards


Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply