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

From: Jasper Smith (jasper_smith9_at_hotmail.com)
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 

-- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"MSSQLServerDeveloper" <MSSQLServerDeveloper@discussions.microsoft.com> 
wrote in message news:B91CD1C5-F72A-4C50-B153-5D418BF1AC16@microsoft.com...
>I was told that running the following from the master db will give me a 
>list
> 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