Media Type Constants (SQLDMO_MEDIA_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Media type constants are used to direct the behavior of the EnumAvailableMedia method of the SQLServer object.
Constant |
Value |
Description |
|---|---|---|
SQLDMOMedia_All |
15 |
Lists all media. |
SQLDMOMedia_CDROM |
8 |
Lists visible CD-ROM devices. |
SQLDMOMedia_FixedDisk |
2 |
Lists visible fixed disk drive devices. |
SQLDMOMedia_Floppy |
1 |
Lists visible floppy disk drive devices. |
SQLDMOMedia_SharedFixedDisk |
16 |
Lists visible fixed disk drive devices shared on a clustered computer. |
SQLDMOMedia_Tape |
4 |
Lists visible tape devices. |