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 |
|
gupta_nag
Starting Member
1 Post |
 Posted - 2003-12-07 : 15:02:52
|
| hi Experts,i have a problem in executing a sp through Query Analyser and ASP command object.The execution time of sp in Query Analyser is taking 2 sec and the same exec statement is getting time out through ADO command object in ASP.exec USP_ENQUIRY_SEARCH @ENROLMENT_NO='BLR',@GROUP_NAME='IGATE'and all remaining queries r working fine and execution time between Query Analyser and ASP also same.so there will not be a problem of Networking stuff.Iam recompiled the sp so many times and i rebuiled the indexes that iam using in the query also and i updated the statistics also..but the same problem is repeating..what will be the problem?can any one guide me. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-08 : 12:25:42
|
| How much data are you returning from the stored procedure? It still could be a network bandwidth problem even though QA and ASP have the same execution time for other queries. Why, because you are reporting a problem.Tara |
 |
|
|
|
|
|
Urgent Exec. time of SP btw Query Analyser and ASP