SQL Server Performance

password in syslogins

Discussion in 'General DBA Questions' started by pcsql, Dec 10, 2004.

  1. pcsql New Member

    When I run select * from syslogins, I got this:

    password:

    #14032;#6894;#9354;#25530;#8535;#20915;#33419;#41265;#55700;#1667;#32693;#38327;#33942;#35467;#57518;#48007;#23646;#52000;#42736;#52431;#4019;#44320;

    language:

    us_english

    I have tried to enter another password but the password is still showing in foreign language.


    Is this right or something is wrong?
  2. thomas New Member

    Passwords are encrypted in syslogins, you can't access them directly in queries. Use sp_password instead (see BOL for details).

    Tom Pullen
    DBA, Oxfam GB
  3. satya Moderator

    Thsoe are stored in binary format with encryption as Tom specified, and its not good practice in the terms of the security.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page