Automatic Execution of Procedures

• Donna Robbins

  Old Hand

  Points: 355

  More actions

  February 28, 2006 at 11:34 am

  #111986

  Good Afternoon All:

  Does anyone know how to tell if a stored procedure has been set to automatic execution at startup?  I executed the sp_procoption to set the proc, but want to verify that it is indeed set to autoexecute on SQL 2005.

  Thanks!

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  February 28, 2006 at 11:57 am

  #623772

  if you have a version of 2005 running on a machine other than production, why not create an sp that has the

  exec sp_procoption N'procname', N'startup', N'true'

  GO

  set and have the sp send an email or insert into a table, when you restart the sql service you will know if it works on 2005

• TDuffy

  SSCarpal Tunnel

  Points: 4170

  More actions

  March 2, 2006 at 7:41 am

  #624305

  Query master.sys.procedures and examine the is_auto_executed (bit) value.

   

  Terry