I have very long stored procedure that require to running for few hours. The current situation is allow the user to start the stored procedure and check the status in the ASP.NET web application.
- Web Page contains single START button only
- Stored Procedure named SP_Retrieve_Internet_Record_Monthly
- Table named tblStatus contains one varchar column named Status.
Some suggestion on the web say calling Web Services Asynchronously,
and other say using delegate.
If you can give some examples it will be greatly appreciated.