SQL Server: List all marked startup SPs

Select StartupProc = name from sys.sysobjects where xtype = 'p'
and OBJECTPROPERTY(id, 'ExecIsStartup') = 1;