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.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 SqlContext.Pipe.Send flush to display

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?
   

- Advertisement -