Home Forums SQL Server 2005 Administering Windows Login Removed but SUSER_SNAME() Still Works RE: Windows Login Removed but SUSER_SNAME() Still Works

  • Thank you! I plan on changing the owner of the maintenance plans and jobs to "sa". The original goal here was to find and update maintenance plans (with corresponding jobs) where the owner is an account belonging to former DBAs who no longer work here. I removed the logins months ago but when I update the maintenance plans they had created with their accounts, the job owner reverts back to their accounts. Then the jobs fail when they run.