System Stored Procedures
- Sp_addextendedproperty - Adds a new extended property to a database object.
- Sp_autostats - Displays or changes the automatic statistics update option.
- Sp_columns - Returns column information for the specified database objects.
- Sp_column_privileges - Returns column privilege information for a table.
- Sp_special_columns - Returns the optimal set of columns that uniquely identify a row in the table.
- Sp_configure - Displays or changes global configuration settings for the current server.
- Sp_databases - Shows all databases name and size for an instance of the SQL Server.
- Sp_execute - Executes a prepared Transact-SQL statement using a specified handle and optional parameter value.
- Sp_executesql - Executes a Transact-SQL statement that can be reused many times.
- Sp_fkeys - Returns foreign key informations.
- Sp_help - List informations about a database objects.
- Sp_helpconstraint - Returns a list of all constraint types.
- Sp_helpdb - List informations about databases.
- Sp_helpindex - Returns information about the indexes on a table or view.
- Sp_lock - Shows information about locks.
- Sp_monitor - Shows statistics about Microsoft SQL Server.
- Sp_prepare - Prepares a parameterized Transact-SQL statement and returns a statement handle for execution.
- Sp_pkeys - Returns primary key informations.
- Sp_rename - Changes the name of a object in the current database.
- Sp_renamedb - Changes a database name.
- Sp_tables - Returns a list of objects like tables or views.
- Sp_helptrigger - Returns the type or types of DML triggers defined on the specified table.
- Sp_table_privileges - Returns a list of table permissions for the specified table.
- Sp_server_info - Returns a list of attribute names and matching values for SQL Server.
- Sp_statistics - Returns a list of all indexes and statistics on a specified table.
- Sp_stored_procedures - Returns a list of stored procedures.
- Sp_unprepare - Discards the execution plan created by the sp_prepare stored procedure.
- Sp_updatestats - Runs UPDATE STATISTICS against all user-defined and internal tables in the current database.
- Sp_who - Returns information about current users, sessions, and processes in an instance of the SQL Server.