🚀 go-pugleaf

Hello,

I am using SQL Server 2000 & BCB6. I am trying to create a 
progress bar for a long running stored procedure by using 
raiserror with nowait to return the percentage back to the 
client without exiting the stored procedure. However those 
errors never seem to make it to the client. I understand that 
anything below error level 19 is more of a warning that can be 
handled without exiting the stored procedure. 

Does anyone know how to handle\catch warnings on the client 
that occurs in the sp or better yet and means with which to 
measure the progress of a stored procedure. Accuracy is not 
that important, I just wish to give the user a rough idea about 
how much more (time?) is required, since I am process rather 
large xml documents (5-60 mgs) it make take awhile.



newbie