Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
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