A transaction deadlock occurs when two or more tasks permanently block each other by each task having a lock on a resource which the other tasks are trying to lock. Both transactions in a deadlock will wait forever unless the deadlock is broken by an external process. This can happen for several reasons, and can happen on any type of server including sql servers.

To Resolve:

-Click OK
-Log out
-Log back in to continue process or perform action again if necessary