Re: sp_procoption and listing all stored procs config to run @ startup

From: Jasper Smith (
Date: 05/18/05

Date: Wed, 18 May 2005 18:31:11 +0100

Looking at the code for sp_procoption that doesn't sound correct. You can
simply use

select name from sysobjects
where objectproperty(id,'ExecIsStartup')=1

Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
"MSSQLServerDeveloper" <> 
wrote in message
>I was told that running the following from the master db will give me a 
> of all the stored procs that are set to run at startup.
> sp_procoption null,'startup'
> However, when I attempt this command, I get the error -
> Procedure 'sp_procoption' expects parameter '@OptionValue', which was not
> supplied.
> Anyone know how to get this to work?? 

Relevant Pages