Server.ReadErrorLog 方法

發行項
08/01/2013

Enumerates the SQL Server error log.

命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Function ReadErrorLog As DataTable
'用途
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

傳回值

型別：System.Data.DataTable
An object that contains an enumerated list of errors from the SQL Server error log.

範例

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