PRB: No RAISERROR in sp_password

ID: Q77189

The information in this article applies to:

Microsoft SQL Server version 4.2x

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 query words: stored procedures Windows NT

Keywords : kbprg SSrvStProc SSrvServer SSrvWinNT
Version : winnt:4.2x
Platform : winnt
Issue type :