BUG: Startup Stored Procedure Using sp_OACreate Fails

WORKAROUND

• Do not use the startup stored procedure; an alternative is to use a scheduled task to run the procedure at an appropriate time.
  
  -or-
• Use xp_cmdshell within a startup stored procedure to run the required stored procedure using ISQL, as in the following example:
  

        CREATE PROC TheStartUp AS
           execute master.dbo.xp_cmdshell 'isql /E /Q"execute <sp_name>" '
        go
  
        sp_makestartup TheStartUp
        go