I renamed an userlogin from 'Mike' to 'Mike2" in the active directory. When I run SUSER_SNAME() from a machine logged in as 'Mike2', the server still returns 'Mike' instead of 'Mike2'. But, after a restart of the server, I get 'Mike2'. Similar issue has been report here:

SQL Server not picking up new NTLogin name

Please note that running "select suser_sname( suser_sid() )", i.e. even when I pass the the sid, I still get the old name before restart.

Request experts to suggest ways to fix this issue without restarting the server.