Display sys procedures in SQL Server Posted by Ray Fox SELECT QUOTENAME(SCHEMA_NAME(schema_id)) + '.' + QUOTENAME(name) FROM sys.all_objects WHERE type = 'P' AND is_ms_shipped = 1