The following actions are taken during an upgrade from an earlier Adaptive Server release (not in a new master database):
Schema changes to syslogins and syssrvroles.
Add a new row to sysattributes for “allow password downgrade,” set with value 1 (default). The ability to downgrade passwords is kept on upgraded master databases until the stored procedure “sp_passwordpolicy set, 'allow password downgrade', 0” is called to disable it. The system attribute “allow password downgrade” is enabled by default upon upgrade.
Add a new row to sysattributes for “enable last login updates,” set with value 1 (default).The update of syslogins column lastlogindate is controlled by this attribute value.The administrator can disable this behavior by calling stored procedure “sp_passwordpolicy set, 'enable last login updates', 0.”
