后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。
The EnumAvailableMedia method returns a QueryResults object that enumerates media visible by an instance of Microsoft SQL Server.
语法
object
.EnumAvailableMedia( [ MediaType ] )as QueryResults
Parts
- object
Expression that evaluates to an object in the Applies To list.
- MediaType
Long integer that optionally restricts output as described in Settings.
Prototype (C/C++)
HRESULT EnumAvailableMedia(
LPSQLDMOQUERYRESULTS* ppResults,
SQLDMO_MEDIA_TYPE MediaType = SQLDMOMedia_All);
Settings
Set the optional MediaType parameter using these SQLDMO_MEDIA_TYPE values.
| Constant | Value | Description |
|---|---|---|
SQLDMOMedia_All |
15 |
Default. List all media. |
SQLDMOMedia_CDROM |
8 |
List visible CD-ROM devices. |
SQLDMOMedia_FixedDisk |
2 |
List visible fixed disk drive devices. |
SQLDMOMedia_Floppy |
1 |
List visible floppy disk drive devices. |
SQLDMOMedia_SharedFixedDisk |
16 |
List visible fixed disk drive devices shared on a clustered computer. |
SQLDMOMedia_Tape |
4 |
List visible tape devices. |
Returns
A QueryResults object that contains one result set defined by these columns.
| Column | Data type | Description |
|---|---|---|
name |
nvarchar(256) |
Mapped name of the media. |
low free |
integer |
Interpreted as an unsigned value. Low-order double word of available media resource. |
high free |
integer |
Interpreted as an unsigned value. High order double word of available media resource. |
media type |
tinyint |
Interpreted using the SQL-DMO enumerated data type SQLDMO_MEDIA_TYPE. |
备注
The SQLDMOMedia_SharedFixedDisk constant is only valid when used with an instance of SQL Server 2000 or later.