Sample Header Ad - 728x90

Help on understanding deadlock

0 votes
0 answers
243 views
deadlock A deadlock issue is encountered when adding column to an existing table, from my attempt to understand the graph, a linked server calling sp_columns_100_rowset is having an update lock on sysschobjs, which is very strange, any idea why is this happening? Deadlock xml: https://pastebin.com/ssGrYZ7q
Asked by JieLong (315 rep)
May 5, 2021, 03:04 AM
Last activity: May 5, 2021, 05:28 AM