Hi ,
I am having a scenario having 2 button Start Process and Cancel Process on a GUI.
When user clicks on the Start Process the back-end process gets started. Meanwhile user realize not to do it he press the Cancel button.But in the back end Transaction already started for the sp_StartProcess.
How can I cancel the process and restored or rollback this.
Please suggest .
Thanks
vd