SQL Server Stored Procedures

/* Stored Procedure */
Sp_databases -- list all databases on the server
Sp_server_info -- list server information, such as character set, version, and order
Sp_stored_procedures -- list all stored procedures in the current environment
Sp_tables -- list all objects that can be queried in the current environment
Sp_start_job -- start the automation task immediately
Sp_stop_job -- stop an automation task in progress
Sp_password -- add or modify the Logon account password
Sp_configure -- display (without options) or change (with options) The global configuration settings of the current server
Sp_help -- return the column name, data type, and constraint type of the table.
Sp_helptext -- display rules, default values, unencrypted stored procedures, user-defined functions,
-- Actual text of a trigger or view
Sp_helpfile -- view the current database information
Sp_dboption -- display or Change Database options
Sp_detach_db -- detach a database
Sp_attach_db -- Additional database
Sp_addumpdevice -- add a device
Sp_dropdevice -- delete a device
Sp_pkeys -- view the primary key
Sp_fkeys -- View Foreign keys
Sp_helpdb -- view the file information of a specified database
Sp_addtype -- user-created data type
Sp_droptype -- delete user-created data types
Sp_rename -- rename the database
Sp_executesql -- execute an SQL statement
Sp_addlogin -- add Logon
Sp_droplogin -- delete Logon
Sp_grantdbaccess -- Maps users to logon, that is, adding a database security account and granting tower Access Permissions
Sp_revokedbaccess -- revokes the user's data access permission, that is, deleting a security account from the database
Sp_addrole -- add a role
Sp_addrolemember -- add a member to the role to become a member of the database role.
Sp_addsrvrolemember -- modify logon to make it a member of a fixed server role
Sp_grantlogin -- allows a group account or a system user to connect to SQL using Windows Authentication
Sp_defaultdb -- modify a default database for Logon
Sp_helpindex -- used to view the table Index
Sp_cursoropen -- Define SQL statements related to the cursor and cursor options, and then generate the cursor
Sp_cursorfetch -- extract one or more rows from the cursor
Sp_cursorclose -- close and release the cursor
Sp_cursoroption -- set various cursor options
Sp_cursor -- used to request location update
Sp_cursorprepare -- compile a cursor-related T-SQL statement or batch into an execution plan without creating a cursor
Sp_cursorexecute -- create and fill the cursor in the execution plan created by sp_cursorprepare
Sp_cursorunprepare -- discard the execution plan generated by sp_cursorprepare
Sp_settriggerorder -- specifies the first or last AFTER trigger associated with the table. In the first
-- The AFTER trigger triggered between the trigger and the last trigger will be executed in an undefined order.