dotlike.net
 

NAVIGATION

PROJECTS

ITKB
 


MSSQL T-SQL: find users with empty passwords


here is a T-SQL job to list SQL-users with empty passwords:


select name, type_desc, create_date, modify_date, default_database_name
from sys.sql_logins
where PWDCOMPARE('',password_hash) = 1


    Article Details:

    FileID : 446
    Keywords : t-sql;mssql;empty password;security
    Authored by : davidr
    Views : 2854
    Submit Date : 2013-07-22 13:37:55
 
ETCETERA

Valid HTML 4.01 Transitional

http://twitter.com/dotlike