G
Guest
Hi
I have a C# (windows app) program where I call several stored procs. However there stored proc are very long (total of about 15-20 minutes)
My Problem is that when a execute the program, it kind of stalls, and its status is NOT RESPONDING. But it seems to execute the Store Proc OK. But we don't see the regular user interface anymore, and it looks like if the program has crashed... Any idea what I can do to smoothen the user experience
(I have put the CommandTimeout to a large number, and I have sure that it is not a connection or privileges problem.
thanks
Jenny
I have a C# (windows app) program where I call several stored procs. However there stored proc are very long (total of about 15-20 minutes)
My Problem is that when a execute the program, it kind of stalls, and its status is NOT RESPONDING. But it seems to execute the Store Proc OK. But we don't see the regular user interface anymore, and it looks like if the program has crashed... Any idea what I can do to smoothen the user experience
(I have put the CommandTimeout to a large number, and I have sure that it is not a connection or privileges problem.
thanks
Jenny