In addition to using SQL Enterprise Manager, you can also administer dump devices by using system stored procedures. A summary of these stored procedures follows. For more information, see the Microsoft SQL Server Transact-SQL Reference.
Note that you are not required to use these stored procedures to manage dump devices. In most cases, SQL Enterprise Manager is the recommended tool.
| Stored procedure | Description |
|---|---|
| sp_addumpdevice | Adds a dump device to SQL Server. |
| sp_dropdevice | Removes a SQL Server dump device or database device. |
| sp_helpdevice | Reports information about SQL Server dump devices and database devices. |