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 SQL Server error log.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function ReadErrorLog As DataTable
'Usage
Dim instance As Server
Dim returnValue As DataTable
returnValue = instance.ReadErrorLog()
public DataTable ReadErrorLog()
public:
DataTable^ ReadErrorLog()
member ReadErrorLog : unit -> DataTable
public function ReadErrorLog() : DataTable
Return Value
Type: System.Data.DataTable
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
Reference
Microsoft.SqlServer.Management.Smo Namespace