Поделиться через


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.

Applies To: