Useful SQL Server System Stored Procedures You Should Know

System Stored Procedures are useful in performing administrative and informational activities in SQL Server. Here’s a bunch of System Stored Procedures that are used on a frequent basis (in no particular order): System Stored ProcedureDescription sp_help Reports information about a database object, a user-defined data type, or a data typesp_helpdb Reports information about a specified database