ServerMessage Event
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The ServerMessage event occurs when a Microsoft SQL Server success-with-information message is returned to the SQL Distributed Management Objects (SQL-DMO) application.
Syntaxe
Private Sub
object
_ServerMessage(
Severity as Long
,
MessageNumber as Long
,
MessageState as Long
,
Message as String
)
Parts
- object
Expression that evaluates to an object in the Applies To list.
- Severity
Long integer that identifies the severity level of a SQL Server error message.
- MessageNumber
Long integer that identifies a SQL Server error message by number.
- MessageState
Long integer that identifies a state value for a SQL Server error message.
- Message
String that contains SQL Server error message text.
Prototype (C/C++)
HRESULT ServerMessage(long Severity, long MessageNumber,
long MessageState, SQLDMO_LPCSTR Message);
Notes
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.