Finding Startup Procedures

  • Jonathan Kehayias

    One Orange Chip

    Points: 26778

    I need to check for startup procedures on a few SQL 2000 servers, and I can't find reference on how to do it.  I know I can do it on 2005 with the following:

    select name from sys.procedures where is_auto_executed=0

    Is there any similar method to do in SQL 2000?  I looked at the sysobjects table where type = 'p' and don't see a designation for what would be startup or not.

    Any help would be appreciated.

    Thanks.

    Jon

     

     

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

  • rubes

    SSCrazy

    Points: 2058

    I think this should work in both 2000 and 2005.

     

    select

    name, objectproperty(id, 'ExecIsStartup')

    from

    sysobjects

    where

    objectproperty(id, 'ExecIsStartup') = 1

    Regards,
    Rubes

  • Sugesh Kumar

    One Orange Chip

    Points: 27311

    Just include xtype='P' alone so that you can limit the search in the system table.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Jonathan Kehayias

    One Orange Chip

    Points: 26778

    Thank you for the information.  It worked perfectly.

     

    Jon

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

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

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