SQL SERVER self-bringing system stored procedure classification

Directory Stored Procedures	Used to implement ODBC data dictionary functionality and isolate ODBC applications from the impact of changes to the underlying system tables.
Change data capture stored procedures	Used to enable, disable, or report on change data capture objects.
Cursor Stored Procedures	Used to implement the cursor variable function.
Data Collector stored Procedures	Used to process the data collector and the following components: Collection sets, collection items, and collection types.
Database Engine stored Procedures	General maintenance for the SQL Server database engine.
Database Mail stored procedures (Transact-SQL)	Used to perform e-mail operations from within an instance of SQL Server.
Database maintenance Plan Stored procedures	Used to set the core maintenance tasks required to manage database performance.
Distributed Query Stored Procedures	Used to implement and manage distributed queries.
Filestream and FileTable stored procedures (Transact-SQL)	Used to configure and manage FILESTREAM and FileTable features.
Full-Text Search stored procedures	Used to implement and query full-text indexes.
Log Shipping stored Procedures	Used to configure, modify, and monitor log shipping configurations.
Automating stored Procedures	Used to enable standard automation objects to be used in standard Transact-SQL batches.
Policy-based management stored procedures	For policy-based management.
Copying stored procedures	Used to manage replication.
Security Stored Procedures	for managing security.
Spatial index stored procedures	Used to analyze and improve index performance of spatial indexes.
SQL Server Profiler Stored procedures	Used by SQL Server Profiler to monitor performance and activity.
SQL Server Agent stored procedures	Used by SQL Server Agent to manage scheduled activity and event-driven activities.
XML Stored Procedures	For XML text management.
General extended stored procedures	Used to provide an interface from an instance of SQL Server to an external program for various maintenance activities.

  Note
to indicate a failure, a value other than 0 is returned.