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.

See Also