I'm trying to create a stored procedure to send mail, and 1 line in my SP states:
EXEC @hr = sp_OACreate 'CDONTS.NewMail', @MailID OUT
But I get an error that sp_OACreate is missing. How it happened I don't know.
But how do I fix the problem? Is it possible to recreate sp_OACreate manually?
(Note that the statement is working on other machines, so it is specific to that server).
The same also happens for sp_OACreate.
I'm running SQL 2000 on Win XP.
The full error message is:
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_OACreate'