A query that returns all system stored procedures listed in MS SQL Server

Question

How can I get all the system stored procedures listed by MS SQL Server (2012) using an SQL query?

Answer 1

sysobjects deprecated. you can use

 SELECT QUOTENAME(SCHEMA_NAME(schema_id)) + '.' + QUOTENAME(name) FROM sys.all_objects WHERE type = 'P' AND is_ms_shipped = 1 

Answer 2

 SELECT sch.name + '.' + obj.name FROM sysobjects obj, sys.schemas sch WHERE obj.type = 'P' AND sch.schema_id = obj.uid AND sch.name = 'sys' --AND obj.name like '%my_search_string%'--use this for filtering ORDER BY sch.name + '.' + obj.name 

Answer 3

 SELECT * FROM sys.all_objects WHERE type = 'P' AND is_ms_shipped = 1 

Answer 4

 SELECT name, type FROM dbo.sysobjects WHERE (type = 'P')