Loading ...
Sorry, an error occurred while loading the content.

Re: Windows Login Issue in SQL Server 2005

Expand Messages
  • bhuvnesh_tutor
    Hi Ajay, Though i am not sure but It can happens because , in active directory ( your profile name ) contains ALIAS name , the same appearing on Select
    Message 1 of 3 , Feb 26, 2010
    • 0 Attachment
      Hi Ajay,

      Though i am not sure but
      It can happens because , in active directory ( your profile name ) contains ALIAS name , the same appearing on Select suser_name().


      Just check whether this is happening only to you or some other guys also?


      --- In sqlcon@yahoogroups.com, Ajay <ajayn_delhi@...> wrote:
      >
      > Hi All,
      >  
      > I am facing a very strange problem. I am login with x (Windows login) using SSMS but when I am running query "SELECT SUSER_NAME()" It's showing y (Windows Login) login.
      >  
      > Any suggestion.
      >
      > Thanks,
      > Ajay Jain
      >
      >
      >
      > Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos
      >
      > [Non-text portions of this message have been removed]
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.