sp_dropdevice

Syntax

sp_dropdevice logicalname

logicalname – is the name of the device as listed in master.dbo.sysdevices.name.

Example 1 – Drops the device named tape5 from SAP ASE:
```
sp_dropdevice tape5
```
Example 2 – Drops the database device named fredsdata from SAP ASE. The device must not be in use by any database:
```
sp_dropdevice fredsdata
```

There are additional considerations when using sp_dropdevice:

sp_dropdevice drops a device from SAP ASE, deleting the device entry from master.dbo.sysdevices.
sp_dropdevice does not remove a file that is being dropped as a database device; it makes the file inaccessible to SAP ASE. To delete a file after using sp_dropdevice, use operating system commands.

See also drop database in Reference Manual: Commands.

The permission checks for sp_dropdevice differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage disk` privilege.
Disabled	With granular permissions disabled, you must be a user with sa_role.

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect