Stored Procedure script to show startup Procs

USE [master]
GO

CREATE proc [dbo].[sp_ShowStartupProcs]
as
SELECT *
FROM [sysobjects]
WHERE [type] = 'P' AND OBJECTPROPERTY(id, 'ExecIsStartUp') = 1;

GO