sa_verify_password system procedure

Function

Validates the password of the current user.

Syntax

sa_verify_password ( string )

Parameters

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Remarks

This procedure is used by sp_password. If the password matches, the procedure simply returns. If it does not match, the error string returned by the procedure is returned.

Side effects

None.