ROSS: Utilities Manage Running/Hung Processes
SQL
fin_prod (right click) Reports Standard Reports All Blocking Transactions
sp_who2
then kill "SPID#"
If there are no locking issues you will get this:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article