June 17, 2009 at 7:21 am
Once a week, after job uses the SP_sendmailhtml provided at this site, the sendmailhtml will not send the email. I have to restart the SQL services. Then it is fine again, until Tuesday after 9 AM. the 9 AM email comes. All other jobs run still. But if I just try to use script in query analyzer that calls sp_sendmailhtml, to send myself an email, I will not get email. It is like an object was not destroyed that sendmailhtml created.
I spoke it over with my boss and he says that the only thing new introduced was the sp_OA... stuff like sp_OAcreate, property, etc. He thinks the object is not getting destroyed at 9 and then when the job runs that calls SP_sendmailhtml, this generates and I have to restart the SQL services
SqlDumpExceptionHandler: Process 157 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 06/16/09 12:00:38 spid 157
*
* Exception Address = 0763E5C6 (DllUnregisterServer + 0001022C Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
I am familiar somewhat with SQL server, I am new to this. Used it as a user, not a developer. What should I look for that is getting stuck, and how to do this? I searched the web for known bugs with sendmailhtml and the OA objects, but nothing makes sense.
June 17, 2009 at 8:30 am
I'm not sure what version of Sql Server you are using but take a look at this:
http://support.microsoft.com/kb/937277
Chim Kalunta
June 17, 2009 at 9:53 am
Thank you for your reply. SQL server version is 2000 SP4 There was a link at the bottom for 2000, and answer was to apply latest SP. That has been done before using this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply