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.