Has anyone ever seen anything like this before? I have a WINDOWS_LOGIN AD user that has a record in
sys.server_principals with a
SID and can login fine. But in a few databases, they have a record in
sys.database_principals with a
I have scoured Google trying to find out what's causing this as it's causing problems with my SQL Server auditing tools but have had no luck.