DetachedDBInfo Method

SQL-DMO

DetachedDBInfo Method

The DetachedDBInfo method returns information about a detached database.

Applies To

SQLServer2 Object

Syntax

object.DetachedDBInfo( MDFName ) as QueryResults

Parts

Object

Expression that evaluates to an object in the Applies To list

MDFName

String that contains the name of the primary Microsoft® SQL Server™ 2000 database file

Prototype (C/C++)

HRESULT DetachedDBInfo(
SQLDMO_LPCSTR MDFName,
LPSQLDMOQUERYRESULTS *ppResults);

Returns

A QueryResults object that contains one result set defined by these columns.

Column	Data type	Description
Property	string	Name of the item returned
Value	sql_variant	The property value

Remarks

The result set returned by DetachedDBInfo contains three rows:

Database name, returned as a Unicode string of sysname data type.
Database version, returned as an integer.
Collation ID, returned as a long integer.

Use the ListDetachedDBFiles method to list detached database files.

Note If an application calls DetachedDBInfo 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.