Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Enumerates the specified SQL Server error log.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function ReadErrorLog ( _
logNumber As Integer _
) As DataTable
'Usage
Dim instance As Server
Dim logNumber As Integer
Dim returnValue As DataTable
returnValue = instance.ReadErrorLog(logNumber)
public DataTable ReadErrorLog(
int logNumber
)
public:
DataTable^ ReadErrorLog(
int logNumber
)
member ReadErrorLog :
logNumber:int -> DataTable
public function ReadErrorLog(
logNumber : int
) : DataTable
Parameters
- 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.
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]
}
}
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace