PRB: No RAISERROR in sp_password

ID: Q77189

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2
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           : 4.2 | 4.2
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 11, 1999