sp_helpdevice

Displays information about database devices and dump devices

sp_helpdb

Displays information about the relationship between database devices and segments in a specific database.

sp_dboption

Allows you to set some specific options for your database, for example, trunc. Log on chkpt.

sp_configure

Allows you to configure your SQL Server system.

sp_addumpdevice

Creates a dump device for a database or transaction log.

sp_dropdevice

Drops a device previously created.

sp_who

Information about processes currently running.

sp_password

Changes a user password.