Showing the current value of allow password downgrade

You can obtain the current value of attribute allow password downgrade by using the following procedure call:

sp_passwordpolicy list, "allow password downgrade"

The output is a result set containing the current value and a message indicating its meaning.

For an upgraded master database that is still maintaining passwords in the old and new encodings, the result is:

sp_passwordpolicy list, "allow password downgrade"
go

value    message
-------- -----------------------------------------------------
       1 Password downgrade is allowed.
(1 row affected)

For an upgraded master database that only uses new password encryption, the result is:

sp_passwordpolicy list, "allow password downgrade"
go

value    message
-------- -----------------------------------------------------
       0 Last Password downgrade was allowed on <datetime>.
(1 row affected)

For a new master database on Adaptive Server 15.0.2 that only uses new password encryption, the result is:

sp_passwordpolicy list, "allow password downgrade"
go

value    message
-------- -----------------------------------------------------
   NULL New master database.
(1 row affected)