Stored Procedure is executing successfully but on UI it's showing under process

Question

1.00/5 (1 vote)

See more:

I have executed a command from mozilla firefox to update the records of a table using while loop in SP for different databases and different records.

Now, It's 30 minutes over now from clicking the command button. I was waiting for Success message on browser.
But when I have checked database, it has been fully completed for all databases and all records.

So, I want to ask why it was not returned success message on browser instead of processing symbol on browser tab.

Posted 29-May-12 22:06pm

Ashish Naval

Add a Solution

Comments

Dylan Morley 30-May-12 4:10am

You need to post the code that is submitting the stored procedure. Otherwise, how can we guess what the problem is?!

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prosan · Answer 1 · 2012-05-29T22:46:00

Solution 2

have you checked the store procedure by passing argument
like :-

SQL

exec storeprocedureName,arg1,arg2,arg3

if not then check it that in how many times it will return result. i think in loop it was stuck.

Posted 29-May-12 22:46pm

Prosan

Comments

Ashish Naval 30-May-12 5:40am

Actually, same proc is working fine for lesser time taking statements and return exact messages from SQL Server. But this statement is some more time taking. I think this is the issue of time. What would you suggest?

Prasad_Kulkarni 14-Jun-12 3:38am

Nothing wrong to down-vote for this answer. 5'ed!

Pratyush Tripathi · Answer 2 · 2012-05-29T22:39:00

Solution 1

plz show the Stored Procedure then do the solution.

Posted 29-May-12 22:39pm

Pratyush Tripathi

Comments

Rahul Rajat Singh 30-May-12 4:42am

This is not a solution. please use the comment/question area for such questions.