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. |