System Stored Procedures

Many administrative activities are performed inside the sql server using system stored procedure.

Following are some of the frequently used system stored procedures in sql server:

• sp_help
• sp_helptext
• sp_depends
• sp_databases
• sp_tables
• sp_storedprocedures
• sp_datatype_info
• sp_helplanguage
• sp_addserver
• sp_dropserver
• sp_password
• sp_rename