Server.EnumAvailableMedia 方法

發行項
07/13/2013

Enumerates a list of media that is visible to the instance of SQL Server on the local area network.

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

語法

'宣告
Public Function EnumAvailableMedia As DataTable
'用途
Dim instance As Server 
Dim returnValue As DataTable 

returnValue = instance.EnumAvailableMedia()

public DataTable EnumAvailableMedia()

public:
DataTable^ EnumAvailableMedia()

member EnumAvailableMedia : unit -> DataTable

public function EnumAvailableMedia() : DataTable

傳回值

型別：System.Data.DataTable
A DataTable object value that contains the available media information. The table describes the different columns of the returned DataTable.

Column	Data type	Description
Name	String	The name of the drive.
LowFree	Int32	The low order double word of available media resource.
HighFree	Int32	The high order double word of available media resource
MediaTypes	Int32	The media type. See MediaTypes.

範例

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

DataTable d = srv.EnumAvailableMedia();
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 = new-object System.Data.Datatable
$d = $srv.EnumAvailableMedia()

Foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}