Microsoft SQL Server 2019 (RTM-CU14) (KB5007182) - 15.0.4188.2 (X64) Nov 3 2021 19:19:51 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Datacenter 10.0 (Build 17763: ) (Hypervisor)
Version of the script
Version: 2022-01-02 13:58:13
What command are you executing?
UPDATE STATISTICS Schema.Table.Index
What output are you getting?
Transaction (Process ID 138) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Question: If we get a error, any error, can we log the error and move to the next instead of failing the job.
Update stats fails with 1205 error
Microsoft SQL Server 2019 (RTM-CU14) (KB5007182) - 15.0.4188.2 (X64) Nov 3 2021 19:19:51 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Datacenter 10.0 (Build 17763: ) (Hypervisor)
Version of the script Version: 2022-01-02 13:58:13
What command are you executing? UPDATE STATISTICS Schema.Table.Index
What output are you getting? Transaction (Process ID 138) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Question: If we get a error, any error, can we log the error and move to the next instead of failing the job.