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 |
|
programmerdad
Starting Member
1 Post |
 Posted - 2008-05-02 : 13:53:17
|
| I have a very long running sqlclr sp (fuzzy matching thousands of addresses) and I just spent 45 min adding onprogress delegates to the classes (had to back up after trying to use eventing, synchronization is not allowed in safe), so I could see the progress output in the sql ide. To get that warm and fuzzy "it's actually working, and I can leave tonight" feeling.But... of course my slick onprogress messages are not even displayed until the process completes. Or is canceled. I've noticed that in some cases (nothing that I've written), progress information is shown while actually in progress, and in other cases it dumps it all out at completion.Is this behavior controllable? Is there a way to flush or prevent the buffering in the first place? |
|
|
|
|
|
SqlContext.Pipe.Send flush to display