Microsoft SQL Server 2014 Unleashed

Useful System Stored Procedures

You are likely to use only a handful of system stored procedures on a regular basis. What procedures you use will depend on the type of work you do with SQL Server and your capacity to remember their names. Table 7.5 contains a sample set of system stored procedures that you may find useful.

TABLE 7.5 Useful System Stored Procedures

Many of the administrative functions performed by SSMS can also be accomplished with system stored procedures. Examples include procedures that start with sp_add and sp_delete, which can be used to add and delete database objects. In addition, more than 90 system stored procedures ...