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 |
|
tmoisan
Starting Member
5 Posts |
 Posted - 2003-10-14 : 16:07:49
|
| I have a DTS job that sends email via SMTP that executes every 10 minutes for every database on my SQL 2000 sp3, Windows 2000 sp2 production server. Lately, I am getting pop-up errors that read:dtsrun.exe The applicationfailed to initialize properly (0x0000142). Click on OK to terminate theapplication." This job used to work fine, but recently i added 10 more database to my production environment. I am wondering if there is a concurrency issue for DTS that is causing this issue since it worked fine with only 5 databases.Has anyone seen these issues before? My KB search came up with nothing. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-14 : 16:14:40
|
| I googled the error and it appears that the problem is with Windows and not SQL Server. Have you tried replacing dtsrun.exe from a known good machine? If that doesn't work, you should consider reinstalling the Windows service pack and installing sp3a (or just reapply sp3) for SQL Server.Tara |
 |
|
|
|
|
|
DTSRun.exe Failed to Initialize