Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
[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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.