Changed system procedures

sp_addlogin

Specifies the password expiration interval, the minimum password length, and the maximum number of failed logins allowed for a specified login at creation.

sp_displaylogin

Displays the login security related parameters configured for a login. The syntax has not changed; however, the output shows the following additional information:

• Whether the account is locked

• The date of the last password change

• The password expiration interval

• Whether the password has expired

• The minimum length of the password

• The maximum number of failed logins allowed before the login is locked

• The current number of failed logins

sp_displayroles

Displays the login security-related parameters configured for a role. The output has changed as described for sp_displaylogin.

sp_helpdevice

Output displays the new dsync setting in the “description” column.

sp_lock

Output displays the new lock owner ID (loid) field.

sp_modifylogin

Use to change password expiration interval, the minimum password length, and the maximum number of failed logins allowed for a specified existing login.

sp_monitorconfig

Displays additional usage statistics for transaction descriptors and DTX participants.

sp_who

Output displays the new block_xloid field, which indicates the lock owner ID of the blocking transaction. The older blocked field in the output is renamed to blk_spid.