PRB: No RAISERROR in sp_password (77189)


The information in this article applies to:

  • Microsoft SQL Server 4.2x
This article was previously published under Q77189

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.
Modification Type:MinorLast Reviewed:2/14/2005
Keywords:kbProgramming KB77189
©2004 Microsoft Corporation. All rights reserved.