ServerMessage Event
Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The ServerMessage event occurs when a Microsoft SQL Server success-with-information message is returned to the SQL Distributed Management Objects (SQL-DMO) application.
Syntax
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);
Hinweise
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.