Sql Server 2005 crashes from time to time
-
Hi, we are having a problem with an SQL Server 2005. We are running multiple scripts to send emails on the server but from time to time the server stops sending emails and we have to do a restart to ensure functionalitsy again. We have already taken care to close all opened connections in the scripts. Any thoughts?
-
Hi, we are having a problem with an SQL Server 2005. We are running multiple scripts to send emails on the server but from time to time the server stops sending emails and we have to do a restart to ensure functionalitsy again. We have already taken care to close all opened connections in the scripts. Any thoughts?
-
Hi, we are having a problem with an SQL Server 2005. We are running multiple scripts to send emails on the server but from time to time the server stops sending emails and we have to do a restart to ensure functionalitsy again. We have already taken care to close all opened connections in the scripts. Any thoughts?
-
Very difficult to suggest something without seeing your code. Deadlocks, Uncommitted transactions and so many other things could happen.
Yes... We are using a standard Stored Procedure as sendmail function. ALTER PROCEDURE [dbo].[sendmail_subsc] @to varchar(200), @copy varchar(200)=null, @bcc varchar(200)=null, @replyto varchar(200)=null, @from varchar(200), @subject varchar(200), @body text, @filename varchar(255)=null AS Declare @iMsg int Declare @hr int --************* Create the CDO.Message Object ************************ EXEC @hr = sp_OACreate 'CDO.Message', @iMsg OUT -- This is to configure a remote SMTP server. EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusing").Value','2' -- This is to configure the Server Name or IP address. EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', 'our smtp server' -- Save the configurations to the message object. EXEC @hr = sp_OAMethod @iMsg, 'Configuration.Fields.Update', null -- Set the e-mail parameters. EXEC @hr = sp_OASetProperty @iMsg, 'To', @To IF @copy IS NOT NULL BEGIN EXEC @hr = sp_OASetProperty @iMsg, 'Cc', @copy END IF @bcc IS NOT NULL BEGIN EXEC @hr = sp_OASetProperty @iMsg, 'Bcc', @bcc END IF @replyto IS NOT NULL BEGIN EXEC @hr = sp_OASetProperty @iMsg, 'ReplyTo', @replyto END EXEC @hr = sp_OASetProperty @iMsg, 'From', @from EXEC @hr = sp_OASetProperty @iMsg, 'Subject', @Subject EXEC @hr = sp_OASetProperty @iMsg, 'HTMLBody', @Body IF @filename IS NOT NULL BEGIN EXEC @hr = sp_OAMethod @iMsg, 'AddAttachment', null, @filename END -- Send mail EXEC @hr = sp_OAMethod @iMsg, 'Send', NULL -- Destry object EXEC @hr=sp_OADestroy @iMsg and the error message we get is that in this procedure the destroy object fails at one point in time and then crashed the whole server. (buffer issue?) here is the error log from the server: 2011-12-28 02:00:51.25 spid55 Stack Signature for the dump is 0x000000015B32F370 2011-12-28 02:00:52.24 spid55 External dump process return code 0x20000001.External dump process returned no errors. 2011-12-28 02:00:52.26 spid55 Using 'dbghelp.dll' version '4.0.5' 2011-12-28 02:00:53.36 spid55 ***Stack Dump being sent to E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump10000.txt 2011-12-28 02:00:53.36 spid55 SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2011-12-28 02:00:53.36 spid55