Post reply

Password null

  • October 28, 2005 at 7:40 pm

    #115473

    Hi,

    I had change the pasword of SA using sp_password and the password changed successfully,  but when i see syslogins in mater database the password of sa in empty.

    Is there anything wrong why it is showing empty in the password field.

     

    from

    Killer

  • October 30, 2005 at 3:43 pm

    #601198

    How are you viewing the syslogins view, via Enterprise Manager or Query Analyzer??

    When you say "...it is showing empty...", do you mean it's an empty string or NULL?

    --------------------
    Colt 45 - the original point and click interface

  • October 30, 2005 at 7:34 pm

    #601205

    Hi Phill,

     

    It is null in the syslogins table.But when i view the sysxlogin table it is not null.

    and in sysxlogin table there are 3 records of login sa.

    from

    Killer

  • October 30, 2005 at 7:42 pm

    #601206

    syslogins is a view on sysxlogins. In the view, the password field is converted from varbinary to nvarchar.

    sysxlogins is an undocumented table, and as such any use is not supported. The view filters sysxlogins on the srvid field which excludes the additional sa logins.

     

    --------------------
    Colt 45 - the original point and click interface

  • October 30, 2005 at 11:41 pm

    #601216

    Lot of information i got from web about the sysxlogins but still i dont understand why sa login have 3 records in sysxlogins table.

    from

    Killer

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply