System level Stored Procedure

All system level stored procedures are stored in MSDB or MASTER Databases, and most begins with characters SP_  . Here is synopsis of the more common system stored procedures.

Sp_tables	List down all the tables and views
Sp_stored_procedures	Lists down all the stored procedures
Sp_server_Info	Provides the server level information such as Version,character set…
Sp_databases	List down all availbale databases on server
Sp_start_job	To start sql agent job
Sp_stop_job	To stop sql agent job
Sp_monitor	Gives a quick snapshot of how server is doing. How much RAM is in use,how busy processor is…
Sp_who	Used to check blocks,who is using a database…
Sp_rename	To change name of any object
Sp_renamedb	Change the name of DB
Sp_help	To find out information about any object in database.
Sp_helptext	This is used to display the actual text that was used to create an object in database.
Sp_addlogin	To add a standard login to the server
Sp_grantlogin	To grant access on sql server to a windows account
Sp_password	Used to change password for standard login