We are executing a SQL job having step loding data into # table (Temp Database) with some 10 Million records using a big query. Whenever we are in th step we get the following errors.
SQL Error Log Details
2007-11-27 12:33:22.27 spid4 Process ID 55:281 owns resources that are blocking processes on Scheduler 0.
Job Log Details
Msg 1205, Sev 13: Transaction (Process ID 59) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001]