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


Type: System.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: System.Data.DataTable
An object that contains an enumerated list of errors from the specified SQL Server error log.


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

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


$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]
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft