Hello Eamon,

You can check the current status through Enterprise Manager (Your server -> Management -> Current Activity -> Process Info).

It will show the details of the SPID (Process ID), Database, Status, Command etc. Choose the appropriate SPID and Right Mouse Click and select "Kill Process".

You can also do from TSQL

Find out the SPID and then execute KILL <SPID>

Hope this helps.

Thanks