title: Terminate a long running SQL command
body: <p>Let's assume that our front-end app (C#) makes a series of connections to SQL Server and executes a series of stored procedures which may take few hours to complete. I need to have a facility to 'Cancel' a running stored procedure. I know that this can be achieved by <code>Sqlcommand.Cancel()</code>, but this does not seem to be effective at all times. Is there a better way to achieve this?</p>