后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。
The DetachedDBInfo method returns information about a detached database.
语法
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 | 
备注
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.
| .gif) 注意: | 
|---|
| 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. | 
Applies To:
| 
 |