sp_procoption and listing all stored procs config to run @ startup

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

Date: Wed, 18 May 2005 10:21:03 -0700

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

  • Re: project BIG AppleCrate
    ... request page "123.123.123.123/NADAOPEN FILE ... webserver gets command, recognizes it as being for NadaNet. ... It sends the command over a serial connection to the Master ... the webpage used to control this internet enabled NadaNet could ...
    (comp.sys.apple2)
  • Re: master database
    ... script to create stored procs only to realize I was in the ... Without a working master, your server is ... >stored procs only to realize I was in the wrong DB.... ... >> I support the Professional Association of SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Need a simple protocol
    ... First byteof master data contain a command code, ... What happens for example if the slave receives a correct packet, ...
    (comp.arch.embedded)
  • Reservation about UART1 FIFO in C8051F34x in MCE mode
    ... F340 as slaves to one Cypress FX2LP as master. ... I had the slave's ISR pulse when it received anything and pulse ... when it received a command byte. ...
    (comp.arch.embedded)
  • RE: Upgrading from Win2k server to 2003
    ... We must run the adprep /forestprep command on the schema operations master, ...
    (microsoft.public.windows.server.migration)