SQLMessageID Property

SQL-DMO

SQL-DMO

SQLMessageID Property

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

Applies To
JobHistoryFilter Object
Syntax

object.SQLMessageID [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

Long integer that identifies a SQL Server error message

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetSQLMessageID(LPLONG pRetVal);

HRESULT SetSQLMessageID(long NewValue);

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.