I suggest you ...

Fix Sql Server table types causing deadlock

Simply creating and declaring a table type will cause a deadlock.

http://rextester.com/DTVOU28940

create type dbo.udt_Days as table (
[Day] tinyint not null
);
go

declare @Days dbo.udt_Days;

Error(s), warning(s):

Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

0 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Anonymous shared this idea  ·   ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base