What if I change the username in Sitecore using SQL command?
UPDATE dbo.aspnet_Users WITH (ROWLOCK) SET UserName = @NewUserName WHERE UserName = @UserName
I tried it and found that I can't see all other user data anymore (see screen shot). But the data does exist in core database.
What could be the issue?