ReadErrorLog Method (SQL-DMO)

The ReadErrorLog method returns a QueryResults object enumerating the contents of a Microsoft® SQL Server™ error log.

Applies To

SQLServer Object

Syntax

object.ReadErrorLog( [ LogNumber ] ) as QueryResults

Part Description
object Expression that evaluates to an object in the Applies To list
LogNumber Optional. A long integer indicating an error log number. When not specified, the current error log is enumerated.

Returns

A QueryResults object containing one result set defined by:

Column Data type Description
Varies, as described in Remarks nvarchar(256) Log entry descriptive text.
ContinuationRow tinyint When 0, the descriptive text returned in the first column is complete. When 1, the descriptive text should be interpreted as a continuation of the previous row’s contents.

Remarks

In the returned QueryResults object, the ColumnName property of the first column reports the operating system filename of the file used to maintain the log.

Prototype (C/C++)

HRESULT ReadErrorLog(
LPSQLDMOQUERYRESULTS* ppResults,
long lLogNumber = 0);

  


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