SQL Server sp_OACreate fails (out of memory condition)
After successfully sending cca 250 e-mails I have error:
DECLARE @hr int
DECLARE @sTmp0 nvarchar(4000)
-- The mailman object is used for sending and receiving email.
DECLARE @mailman int
EXEC @hr = sp_OACreate 'Chilkat.MailMan2', @mailman OUT
select @hr -- -2147024882
select @mailman -- null
The solution is to call sp_OADestroy when finished with each of the ActiveX objects
For example:
EXEC @hr = sp_OADestroy @mailman
EXEC @hr = sp_OADestroy @email
admin
0
Tags :