EnumAvailableMedia Method
未來的 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.