suser_name() returns old logon data(instead of giving changed logon info)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sudhivns
    New Member
    • Nov 2007
    • 52

    suser_name() returns old logon data(instead of giving changed logon info)

    Hi,
    1.Initially i had user name as "User1" in Active Directory.
    2. When logged into system A as "User1" queried for suser_name(), it returned "User1" as expected
    3. Now in Active Directory, changes "User1" to "TestUser1" as logon name.
    4. Logged onto System A as "TestUser1" and suser_name() giving "User1" instead of "TestUser1" .
    5. After certain time(>5mins), suser_name() giving "TestUser1" .

    Is any parameter linked connection timeout ?
    why suser_name() not returning correct logon info, though i have logged into system with new logon name ?
    Please help
  • sudhivns
    New Member
    • Nov 2007
    • 52

    #2
    Workaround: Restart the machine where SQL server installed.

    Comment

    Working...