EnumAvailableMedia Method
Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.
The EnumAvailableMedia method returns a QueryResults object that enumerates media visible by an instance of Microsoft SQL Server.
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. |
Hinweise
The SQLDMOMedia_SharedFixedDisk constant is only valid when used with an instance of SQL Server 2000 or later.