Microsoft KB Archive/77189

= PRB: No RAISERROR in sp_password =

Article ID: 77189

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



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.

Additional query words: stored procedures Windows NT

Keywords: kbprogramming KB77189

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.