DetachedDBInfo Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The DetachedDBInfo method returns information about a detached database.
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.