We have a number of stored procedures that run on startup via the sp_procoption startup:
exec sp_procoption 'ProcName', 'startup, 'true'
A customer's server started up with a very large database in recovery mode. This is a large database, so recovery will take a long while to complete.
According to the docs:
Execution of the stored procedures starts when all databases are recovered and the "Recovery is completed" message is logged at startup.
The startup procs were not run because the system is in recovery mode, and our software doesn't work if they aren't run. We can run these procs manually to get the system working.
However, after the recovery completes, will the startup procs be run again? That would be bad for us, because as written the procs drop some tables that may be in use by people since the server restarted.