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?

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