startup procedure listing

  • Is there a way to see which all are the startup procedures in the server. In 6.5 we had sp_helpstartup. after upgrading to 2000, I find using sp_procoption I can only set or reset 'startup' of a particular procedure. no eqvt of sp_helpstartup available . I feel it should have been there

  • You can try:

    use master

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


    Cheers,
    - Mark

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply