I have a stored procedure that taps into the sp_OACreate and method stored procedures to use CDONTS to send an email. My problem is that the sp_OAMethod call fails intermittently. Even when sending the exact same parameters and values, sometimes it works, sometimes it doesn't. I really am at a loss to try to troubleshoot this. Any ideas?

This is the stored procedure that sends the mail.

Code:
CREATE PROCEDURE sproc_sendMail 
	@from VARCHAR (50),
	@to VARCHAR (50),
	@subject VARCHAR (100),
	@body VARCHAR (2000)
AS

DECLARE @result INT
DECLARE @object INT

Print 'Creating the CDONTS.NewMail object'
EXEC @result = sp_OACreate 'CDONTS.NewMail', @object OUTPUT
IF @result <> 0
BEGIN
	PRINT 'sp_OACreate Failed'
	RETURN @result
END


PRINT 'Sending the message using the Send method'
EXEC @result = sp_OAMethod @object, 'Send', NULL, @from, @to, @subject, @body
IF @result <> 0
BEGIN
	PRINT 'sp_OAMethod Failed'
	RETURN @result
END

PRINT 'Destroying the CDONTS.NewMail object'
EXEC @result = sp_OADestroy @object
IF @result <> 0
BEGIN
	PRINT 'sp_OADestroy Failed'
	RETURN @result
END

RETURN 0
GO
And this is a simple query that I have been running to test the SP:

Code:
DECLARE @result INT
EXEC @result = sproc_sendMail 'taranis@spittingllamas.com',
    'taranis@spittingllamas.com',
    'My test message',
    'Hello world! Look at my body!'
PRINT @result