1 Version 4.0 -- 1/15/89 sp_dropdevice
______________________________________________________________________
NAME: sp_dropdevice
FUNCTION:
Drops a SQL Server database device or dump device.
SYNTAX:
sp_dropdevice logicalname
EXAMPLES:
1) sp_dropdevice tape5
Drops the device named tape5 from SQL Server.
sp_dropdevice Version 4.0 -- 1/15/89 2
______________________________________________________________________
2) sp_dropdevice fredsdata
Drops the database device named fredsdata from SQL Server.
Device must not be in use by any databases.
PARAMETERS:
logicalname - is the name of the device as listed in
master.dbo.sysdevices.name.
COMMENTS:
o The sp_dropdevice procedure drops a device from SQL Server,
deleting the device entry from master.dbo.sysdevices.
o You must restart SQL Server after you drop a device.
3 Version 4.0 -- 1/15/89 sp_dropdevice
______________________________________________________________________
WARNING ________________________________________________________
| |
| You must restart because the kernel has a process that is |
| accessing the dropped device; there is no way to kill the |
| process. Restarting frees up the logical device number. |
| Restart with startserver or dataserver. |
|_______________________________________________________________|
MESSAGES:
The device has been dropped from the master.dbo.sysdevices table.
You tried to drop a device that doesn't exist on SQL Server.
Only the System Administrator may add or drop devices.
Only database devices that are not in use can be dropped. You
must drop all the databases associated with the device before
dropping the device.
sp_dropdevice Version 4.0 -- 1/15/89 4
______________________________________________________________________
PERMISSIONS:
Execute permission to System Administrator.
TABLES USED:
master.dbo.sysdevices
SEE ALSO:
sp_addumpdevice, sp_helpdb, sp_helpdevice, DROP DATABASE