Simon,
I did something similar a few weeks ago by launching a separate window when the long process start running. This separate window starts its own connection and when users click the CANCEL button I just close this separate window (closing the connection as well.)
In my case the long running request was a call to a web service, not a stored procedure, but the logic might apply to you as well.
>Is it possible in .Net to accept a Cancel button click while a long running stored procedure is in progress, and to then cleanly stop the SQL Server process or similar?
>
>TIA,
>Simon
Hector Correa