Ending an endless loop

[stiej]

Hi,

Is there a way to break a loop, after executing an active X script or anythign that runs a loop that is unintentionally endless, in Enterprise manager/DTS designer???? Rather than doing an Endtask on mmc.exe????

Thanks!

 

[DrSql]

Find which spid is running that job, use (sp_who2 in QE).
Then use (kill Spid#).
Also you can go trhough EM, Management==> Process==> Current Activity, right click the spid and kill the process.

Dr.Sql
Good Luck.

 

[stiej]

Excellent. thanks for the rply. just one quick extra question, if i ran the task within DTS directly, via right cliking it and executing the step, what would i be looking for within the current acativity/sp_who output? thanks again for your help.

 

[DrSql]

From Current Activity look for the "Application" column. Its shoudl say DTS Designer. And in SP_Who2 look for programName

Dr.Sql
Good Luck.