Your question, your audience. Choose who sees your identity—and your question—with question security.
[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
Join the community of 500,000 technology professionals and ask your questions.