Re: sp_procoption and listing all stored procs config to run @ startup
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: Wed, 18 May 2005 18:31:11 +0100
Looking at the code for sp_procoption that doesn't sound correct. You can
select name from sysobjects
-- 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??