SQL-DMO
EnumAvailableMedia Method
The EnumAvailableMedia method returns a QueryResults object that enumerates media visible by an instance of Microsoft® SQL Server™ 2000.
Applies To
| SQLServer Object |
Syntax
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. |
Remarks
The SQLDMOMedia_SharedFixedDisk constant is only valid when used with an instance of SQL Server 2000.