ListDetachedDBFiles Method
The ListDetachedDBFiles method lists all database files referenced by a primary database file.
Applies To
SQLServer2 Object |
Syntax
object.ListDetachedDBFiles( MDFName ) as NameList
Parts
object
Expression that evaluates to an object in the Applies To list
MDFName
String that contains the name of a detached Microsoft® SQL Server™ 2000 database file
Prototype (C/C++)
HRESULT ListDetachedDBFiles(
SQLDMO_LPCSTR MDFName,
LPSQLDMONAMELIST *ppFileNames);
Remarks
An application calls ListDetachedDBFiles to retrieve a complete list of detached database files. The application can then call IsDetachedPrimaryFile to determine which of the files is the primary file.
Note If an application calls ListDetachedDBFiles on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned.