Showing the current value of allow password downgrade

Use this to obtain the current value of attribute allow password downgrade:

sp_passwordpolicy list, "allow password downgrade"

The result set contains 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)