Viewing 2 posts - 1 through 3 (of 3 total)
Gail, that's true for transactions with the same deadlock priority, but it seems to me that SS2008R2 is picking winners by assigning a non-zero default deadlock priority to some queries....
February 15, 2012 at 3:23 pm
#1447583
Very nice solution but I had to change
set @columns_sql =
...
FROM
' + @TgtDB + '.information_schema.columns tgt
January 23, 2012 at 9:41 am
#1437205