Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2002-04-04 : 09:00:46
|
| I'm running sql-2000 with all applied service packs and I have a dts package that sends an Email every night. 80% of the time the dts package get's stuck and does not kick off the Email.When I copy and paste the T-sql code in query analyzer I notice that I'm getting the following error evertime xp_sendmail tries to run:ODBC: Msg 0, Level 19, State 1SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.I restart the SQL service and then try and it works, but I have to do this every morning including Saturdays and Sundays.Any Advice would be much appreciated. |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-04 : 09:28:20
|
| This is a bug introduced in Service Pack 2. I had to deal with the same issue not too long ago. Check out this thread: http://sqlteam.com/forums/topic.asp?TOPIC_ID=13849---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
 |
|
|
|
|
|
sp_sendmail gets stuck every night - FRUSTRATING!!