Server.EnumServerAttributes 方法

项目
07/14/2013

Enumerates a list of server attributes for the instance of SQL Server.

命名空间： Microsoft.SqlServer.Management.Smo
程序集： Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
Public Function EnumServerAttributes As DataTable
用法
Dim instance As Server 
Dim returnValue As DataTable 

returnValue = instance.EnumServerAttributes()

public DataTable EnumServerAttributes()

public:
DataTable^ EnumServerAttributes()

member EnumServerAttributes : unit -> DataTable

public function EnumServerAttributes() : DataTable

返回值

类型：System.Data.DataTable
A DataTable object value that contains a list of server attributes for the instance of SQL Server. The table describes the different columns of the returned DataTable.

Column	Data type	Description
attribute_id	Int32	The ID value that uniquely identifies the attribute.
attribute_name	String	The name of the attribute.
attribute_value	String	The current setting of the attribute.

示例

Server srv = new Server("(local)");

DataTable d = srv.EnumServerAttributes();
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.EnumServerAttributes()
foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}