Progress bar for stored procedure

I'm calling a stored procedure from asp.net front-end. It usually do inserts on many tables. On the front-end I would like to show 2 things: Progress bar like how much is completed. The second thing to show is current database insertion. like: CURRENTLY INSERTING开发者_如何转开发: tblCustomers

Appreciated!

You'll likely need a log table that your front-end would monitor the progress on. This would also require the existing stored proc to log an update to this table between different insert/statuses. Your front-end would need some ajax to query a total records to insert and currently inserted to get your progress bar.