My stored procedure runs great when I execute it from the
Query Analyzer but when I execute it from my DTS package
on the same data it stops processing after 15 or so
records. Literally just stops. There are 278 recs in my
test data and it has stopped on 12, 15, 16, 17, and 21.
When I execute it from the Query Analyzer it processes all
278. What is the difference between those two
platforms???? My proc opens and uses a Cursor and loops
through all the records doing updates and inserts,
depending on certain criteria. Then at the end (right
before the Return), I send an email with status and
counter info. The email gets sent on the Query Analyzer
run. Please Help!!!
Thanks.

I suggest you use Profiler to trace what exactly is happening when you run
your procedure from DTS.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm


"Kym Harper" <kharper (AT) bcharrispub (DOT) com> wrote

My stored procedure runs great when I execute it from the
Query Analyzer but when I execute it from my DTS package
on the same data it stops processing after 15 or so
records. Literally just stops. There are 278 recs in my
test data and it has stopped on 12, 15, 16, 17, and 21.
When I execute it from the Query Analyzer it processes all
278. What is the difference between those two
platforms???? My proc opens and uses a Cursor and loops
through all the records doing updates and inserts,
depending on certain criteria. Then at the end (right
before the Return), I send an email with status and
counter info. The email gets sent on the Query Analyzer
run. Please Help!!!
Thanks.