ID Number: Q77189
1.11 4.20
OS/2
Summary:
SYMPTOMS
The global variable @@ERROR is not set if the sp_password procedure
fails because the wrong password is supplied.
CAUSE
This is expected behavior of SQL Server. The sp_password procedure
does not use the RAISERROR statement on error conditions. Instead,
it prints out a message and exits the procedure.
Additional reference words: 1.11 4.20 stored procedures