Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Stellafish
Starting Member
2 Posts |
 Posted - 2009-03-05 : 13:51:39
|
| Dear all,Apologies for a dumb question but i've had a complete mind blank.I have an update script used to update a large amount of records. Because of the volumes involved, it runs in iterations of 1000 recods at a time.To be able to keep track of how far along the script is, after every iteration, it prints the current counter value.What I want to know, (an I'm almost certain there is), is there a trasact sql statment I can use before the print to clear the messages window.Currently it looks like this:Iteration 1 CompleteIteration 2 Complete Iteration 3 CompleteIteration 4 Completeetcetcbut I want it to clear the previous message before it prints the next count?Any ideas? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-05 : 14:07:13
|
| dont think so.. if you think you are getting too many messages, perhaps you can increase the count to alternate iterations or some multiple of 3 or 4.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Clear Messages from Query Analyser