Finding Startup Procedures

• Jonathan Kehayias

  One Orange Chip

  Points: 26778

  More actions

  July 23, 2007 at 3:08 pm

  #118001

  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

  More actions

  July 23, 2007 at 3:19 pm

  #721706

  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

  More actions

  July 24, 2007 at 6:15 am

  #721858

  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

  More actions

  July 24, 2007 at 7:17 am

  #721890

  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]