sp_helpdevice

Description

Reports information about a particular device or about all Adaptive Server database devices and dump devices.

Syntax

sp_helpdevice [devname]

Parameters

devname

is the name of the device about which to report information. If you omit this parameter, sp_helpdevice reports on all devices.

Examples

Example 1

Displays information about all the devices on Adaptive Server:

sp_helpdevice

device_name  physical_name   description
----------- --------------  -------------------------------------------
diskdump     null            disk, dump device 
master       d_master        special, default disk, dsync on,physical
                                                             disk, 10 MB
status       cntrltype          device_number          low       high 
------       ----------         -------------          ----      -----
16           2                  0                      0         20000 
3            0                  0                      0         5120

Example 2

Reports information about the dump device named diskdump:

sp_helpdevice diskdump

Usage

Permissions

Any user can execute sp_helpdevice.

See also

Commands disk init, dump database, dump transaction, load database, load transaction

System procedures sp_addumpdevice, sp_deviceattr, sp_diskdefault, sp_dropdevice, sp_logdevice