Server.ReadErrorLog Server.ReadErrorLog Server.ReadErrorLog Method

Definition

Enumerates the SQL Server error log.

Overloads

ReadErrorLog() ReadErrorLog() ReadErrorLog()

Enumerates the SQL Server error log.

ReadErrorLog(Int32) ReadErrorLog(Int32) ReadErrorLog(Int32)

Enumerates the specified SQL Server error log.

ReadErrorLog() ReadErrorLog() ReadErrorLog()

Enumerates the SQL Server error log.

public:
 System::Data::DataTable ^ ReadErrorLog();
public System.Data.DataTable ReadErrorLog ();
Public Function ReadErrorLog () As DataTable
Returns

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

Examples

C#

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

DataTable d = srv.ReadErrorLog();  
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()  
foreach ($r in $d.Rows)  
{  
   Write-Host "============================================"  
   Foreach ($c in $d.Columns)  
   {  
      Write-Host $c.ColumnName "=" $r[$c]  
   }  
}  
See Also

ReadErrorLog(Int32) ReadErrorLog(Int32) ReadErrorLog(Int32)

Enumerates the specified SQL Server error log.

public:
 System::Data::DataTable ^ ReadErrorLog(int logNumber);
public System.Data.DataTable ReadErrorLog (int logNumber);
Public Function ReadErrorLog (logNumber As Integer) As DataTable
Parameters
logNumber
Int32 Int32 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.

Returns

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

Examples

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]  
   }  
}  

Applies to