Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pv
Starting Member
1 Post |
 Posted - 2011-11-29 : 01:24:26
|
| 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:http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/50561904-ee03-45ed-a473-e5b95a155264Please 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 you to suggest ways to fix this issue without restarting the server. |
|
|
pduffin
Yak Posting Veteran
68 Posts |
Posted - 2011-11-30 : 18:33:12
|
| I'm not 100% sure, but I think this is a network feature and not a SQL one. I'm sure if you look for your machine on the network it will still show as Mike rather than Mike2 before your reboot.Likes to run, hates the runs! |
 |
|
|
|
|
|
SELECT SUSER_SNAME() returns old user login