Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Show SQL authentication login information

By Rudy Panigas,

Copy and paste this code and execute

 

Here is a list of information at this displayed.

Bad Password Count
Bad Password Time
Days Until Expiration
Default Database
Default Language
History Length
Is Expired
Is Locked
Is Must Change
Lockout Time
Password Hash
Password Last Set Time
User name

Total article views: 2722 | Views in the last 30 days: 7
 
Related Articles
FORUM

Passwords

Storing passwords securely

FORUM

password issues

password issues

FORUM

Password change

Password change

FORUM

password polacy

password polacy

FORUM

password policies

password policies

Tags
security    
 
Contribute