ServerMessage Event (SQL-DMO)

The ServerMessage event occurs when a Microsoft® SQL Server™ success-with-information message is returned to the SQL-DMO application.

Applies To

SQLServer Object

Syntax

Private Sub object_ServerMessage( Severity as Long ,
MessageNumber as Long , MessageState as Long , Message as String )

Part Description
object Expression that evaluates to an object in the Applies To list
Severity Long integer identifying the severity level of a SQL Server error message
MessageNumber Long integer identifying a SQL Server error message by number
MessageState Long integer identifying a state value for a SQL Server error message
Message String containing SQL Server error message text

Remarks

For SQL Server, error severity indicates the degree of an error condition. Some errors are severe enough to terminate statement execution prematurely. Any error with a severity of 10 or higher is returned to the SQL-DMO application through normal error handling.

More benign errors indicate that statement execution succeeded, but that success was conditional. Success-with-information errors, called messages, are SQL Server errors with a severity of less than 10. Some Transact-SQL statements, such as the PRINT statement, do not generate result sets, using messages for their return value.

Implement a ServerMessage event handler to capture SQL Server messages raised by SQL-DMO application processing.

Prototype (C/C++)

HRESULT ServerMessage(long Severity, long MessageNumber,
long MessageState, SQLDMO_LPCSTR Message);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.