Question

sp_OACreate is missing

sp_OACreate, Stored procedures, SQL Server errors, Windows XP, SQL Server 2000, SQL stored procedures

Hi
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'

Grab the install CD for SQL Server 2000. On the disk in the INSTALL folder grab the odsole.sql file and run it in the master database on your server. This will install all the sp_OA procedures.