Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Enumerates a list of SQL Server error log files.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function EnumErrorLogs As DataTable
'Usage
Dim instance As Server
Dim returnValue As DataTable
returnValue = instance.EnumErrorLogs()
public DataTable EnumErrorLogs()
public:
DataTable^ EnumErrorLogs()
member EnumErrorLogs : unit -> DataTable
public function EnumErrorLogs() : DataTable
Return Value
Type: System.Data.DataTable
A DataTable system object value that contains a list of SQL Server error log files. The table describes the different columns of the returned DataTable.
Column |
Data type |
Description |
|---|---|---|
Urn |
The URN string that identifies the error log. "Server[@Name='MYSERVER']/ErrorLog[@ArchiveNo='2']". |
|
Name |
The name of the error log file. |
|
ArchiveNo |
The archive number that denotes the chronological sequence that the error log was created. 0 for the most recent error log, and 1 is the next most recent. |
|
CreateDate |
The date and time when the error log was created. |
|
Size |
The size of the error log file in bytes. |
Examples
C#
Server srv = new Server("(local)");
DataTable d = srv.EnumErrorLogs();
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.EnumErrorLogs()
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