Click here to Skip to main content
14,430,298 members

Second stored procedure take too long time

ahmad_yossef asked:

Open original thread
i have c# application when user click on button it do two thing
first save data into table using stored procedure
second save the same data in another server using stored procedure but this server is on another location and connection alittle slow
i need to make second procdure run async i don't need a result from it
as when user click he must wait to the two procedures to be completed
i need the user interface activated as soon as the first procedure completed

What I have tried:

make a trigger on the first table that inserted data goto the second database and remove the 2nd proceudre but it take a long time also
Tags: C#, SQL-Server


When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. 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.
  4. 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.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100