Server.EnumDetachedDatabaseFiles Method
SQL Server 2005
Enumerates a list of detached database files.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
public StringCollection EnumDetachedDatabaseFiles ( String mdfName )
public function EnumDetachedDatabaseFiles ( mdfName : String ) : StringCollection
Parameters
- mdfName
A String value that specifies the file name for which to limit the results.
Return Value
A StringCollection system object value that contains a list of detached database file names.'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.
