SQL Server comes with stored procedures that can assist you in managing areas of the server. A full list of procedures can be viewed at Microsoft’s MSDN site.