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

From: MSSQLServerDeveloper (MSSQLServerDeveloper_at_discussions.microsoft.com)
Date: 05/18/05 

Date: Wed, 18 May 2005 11:08:05 -0700

Thank you Jasper

"Jasper Smith" wrote:

> 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