situation about a query that it is executing
Hi all. I am a c# programmer. I have a update query that it need 2 minutes for executing (for each reason). I don't want discuss about its performance. My question is: How can I find about situation about a query that it is executing now and it has not executed completely yet. for example How can find my c# code how many records are affected by my query every 10 seconds while that query is executing? Is sql profiler says that to us?
October 8th, 2010 5:29pm
Hi, Currently, there is no process to handle this situation that i am aware of. If you have any concern about this, please submit a feedback at https://connect.microsoft.com/ and hope microsoft enable this feature in the future release. thanks, Jerry
October 12th, 2010 12:02pm