Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Server.ReadErrorLog Method (Int32)

Enumerates the specified SQL Server error log.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public DataTable ReadErrorLog(
	int logNumber
)

Parameters

logNumber
Type: Int32
An Int32 value that specifies the index number of the error log required. Error logs are listed 0 through 9 where 0 is the current error log and 9 is the oldest.

Return Value

Type: DataTable
An object that contains an enumerated list of errors from the specified SQL Server error log.

C#

Server srv = new Server("(local)");

DataTable d = srv.ReadErrorLog(1);
foreach (DataRow r in d.Rows)
{
   Console.WriteLine("============================================");
   foreach(DataColumn c in d.Columns)
   {
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString());
   }
}

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

$d = $srv.ReadErrorLog(1)
foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}

Community Additions

ADD
Show:
© 2015 Microsoft