SQLMessageID Property (SQL-DMO)

The SQLMessageID property identifies a Microsoft® SQL Server™ error message by message number.

Applies To

Syntax

object.SQLMessageID [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Long integer identifying a SQL Server error message

Remarks

Set SQLMessageID to filter for jobs that, as part of processing, generated the error number specified. Set SQLMessageID to -1 to stop filtering by error message raised.

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetSQLMessageID(LPLONG pRetVal);

HRESULT SetSQLMessageID(long NewValue);