sysmail_event_log last_mod_user has a disabled login

• webrunner

  SSC-Dedicated

  Points: 31863

  More actions

  May 29, 2024 at 8:53 pm

  #4424771

  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?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  May 30, 2024 at 9:10 pm

  #4425188

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

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

• andreas.kreuzberg

  SSCertifiable

  Points: 6191

  More actions

  May 31, 2024 at 7:49 am

  #4425294

  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

  Andreas