Yes I agree, I Have Never Faced Such a Problem In My Experience Till Now. The Execution Stmt. I M Running IN QA Is Directly Taking From The The Profiler Stmt. Thats Excuted When Called From Front End App.

My Procedure Is Very Long, I Have Found THat When Called From VB Application, Initially It Executes As Fast as From QA. But After It Reaches Some Particlar Query It Slows Down. THe DiskIO at That Time Stops Changing Quickly. Previously...

M Using SQL Server 2000 And VB6 Application.
When The Procedure Is Executed From Query Analyser It Executes in around 30 Minutes. But When Exeuted From The Application Does Not Come Out Even After 12 Hrs.
I Have Found That The Procedure During Execution Comes at Some Query Which Uses Hash Tables And Stops at That Query.

However The Query Executes Quickly When The Same Procedure Is Executed From The Query Analyser....