Apparently the stored proc RenameTrustee raises error using WITH LOG. I don't recall ever seeing one these berfore but my SQL monitoring caught it this morning:
Message
Error: 50000, Severity: 16, State: 1.
Message
Unable to rename trustee: Cannot rename to asteves, trustee already exists.
I'm not sure why this is going to error log? Is there something that needs to be done? It looks to me like an application business rule and not really a system error concerning the health of the SQL Server.
Does this need attention? I'm really wondering why this error is being logged?
SQL Server Msg 50000
Moderator: Phil Barton
Re: SQL Server Msg 50000
Yes, the RenameTrustee procedure raises the error using "WITH LOG" when it finds a trustee record already existing with the new name. It appears someone is attempting to rename a Select user to "asteves" but there's already a user named "asteves".