Post reply

How to disable startup stored procedures during an upgrade?

  • August 23, 2018 at 3:23 am

    #367559

    Prior to the upgrade process, we should take preventative measures to avoid common upgrade issues, such as running out of disk space or executing startup stored procedures during the upgrade. My question is how to identify startup stored procedures(where is their location) and how to disable them.
    Thanks for your time!

  • August 23, 2018 at 3:40 am

    #2003014

    Hi,

    You can get a list of stored procedures that runs on startup by:

    SELECT * FROM sys.procedures WHERE OBJECTPROPERTY([object_id],'ExecIsStartUp') = 1

    If you want disable them, you can make use of sp_procoption stored procedure in this way:

    exec sp_procoption '<your procedure name>', 'startup', 'off'

  • August 23, 2018 at 3:48 am

    #2003016

    debasis.yours - Thursday, August 23, 2018 3:40 AM

    Hi,

    You can get a list of stored procedures that runs on startup by:

    SELECT * FROM sys.procedures WHERE OBJECTPROPERTY([object_id],'ExecIsStartUp') = 1

    If you want disable them, you can make use of sp_procoption stored procedure in this way:

    exec sp_procoption '<your procedure name>', 'startup', 'off'

    Thanks

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

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