SQL Server Performance Forum – Threads Archive

password in syslogins

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?

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

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.

]]>