Showing the current value of allow password downgrade

To obtain the current value of allow password downgrade enter:

sp_passwordpolicy list, "allow password downgrade"

The result set includes the current value, and a message indicating its meaning.

If you have upgraded the master database, and are maintaining passwords with 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)