Click here to Skip to main content
15,664,823 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi all. I have a huge update query that effects many many records. in each reason, this query need 3 or 4 minutes for execute.
not discuss about optimize query.

I want to find this query situation by c# code for every 10 seconds or more.

Just I want to find situation of query. for example count of records are affected by c# code in every 30 seconds.

I know how can I show a news for users regularly too.

what should I do? how sql server says this to us? what I need for communication between c# and sql server? Is this possible?

If I understand your question correctly, you want to start the update, and then show progress messages every 10 seconds.

You could make the stored proc that's doing the update write a status indicator of some kind to a table, and from a thread in your app, check that status indicator every 10 seconds.

That's the way I'd try it first.
Share this answer
[no name] 6-Oct-10 8:41am    
Yes I want start the update, and then show progress messages every 10 seconds. for example how many records are affected in every 10 seconds. what should I do?
[no name] 7-Oct-10 6:23am    
No one know ???
[no name] 7-Oct-10 6:23am    
Please help me ...
I think I should use TraceServer class. right?
Share this answer

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900