[Execute SQL Task] Error: Executing the query "declare @dt as datetime2
set @dt = SYSDATETIME()
..." failed with the following error: "Transaction (Process ID 94) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
declare @dt as datetime2 set @dt = SYSDATETIME() EXECUTE [SP_0_TEMP_DELETE] EXECUTE [SP_1_TEMP_APPEND] EXECUTE [SP_2_TEMP_APPEND_EXPIRED_RENEWALS] EXECUTE [SP_3_UPDATE] @dt EXECUTE [SP_4_UPDATE_EXPIRED_RENEWALS] @dt EXECUTE [SP_5_APPEND] @dt
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.