• SSIS, CLR, sp_OAMethod or another method to call web method

    I have a question on which method is the best practice. I have been given a task to run a web service method every 5 minutes. There is one input parameter and no output to return. The service runs a bunch of functions to do data validation and then inserts into a DB2 database. (could not get a...

    ToddN200056,155 pointsBadges:
  • sp_OACreate is missing

    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?...

    Kowalski5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.