System Stored Procedures (Transact-SQL)

In SQL Server 2005, many administrative and informational activities can be performed by using system stored procedures.

http://msdn2.microsoft.com/en-us/library/ms187961.aspx