Query returning all system stored procedures listed by 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 is 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