Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2012-04-03 : 10:40:50
|
Hello,
Is there a query that will show logins that are NOT set to enforce the password policy and password expiration?
Thanks,
Terry |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-03 : 11:37:51
|
[code]SELECT is_policy_checked
FROM sys.sql_logins
WHERE name = 'SQL Login Name Here'[/code] |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-04-03 : 11:39:31
|
For returning all unchecked
SELECT name
FROM sys.sql_logins
WHERE is_policy_checked = 0
|
|
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2012-04-04 : 08:20:50
|
Perfect - Thank you!
Thanks,
Terry |
|
|
|
|
|
|
Password Policy Query