Server.EnumDirectories Method
SQL Server 2005
Enumerates a list of directories relative to the specified path.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
public DataTable EnumDirectories ( String path )
public function EnumDirectories ( path : String ) : DataTable
Parameters
- path
A String value that specifies an operating system path.
Return Value
A DataTable system object value that contains a list of directories relative to the specified path. The table describes the different columns of the returned DataTable.|
Column |
Data type |
Description |
|
Name |
String |
The name of the directory relative to the specified path. |
'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server 'Call the EnumCollations method and return collation information to DataTable variable. Dim d As DataTable 'Select the returned data into an array of DataRow. d = srv.EnumCollations 'Iterate through the rows and display collation details for the instance of SQL Server. Dim r As DataRow Dim c As DataColumn For Each r In d.Rows Console.WriteLine("============================================") For Each c In r.Table.Columns Console.WriteLine(c.ColumnName + " = " + r(c).ToString) Next Next
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.