Deadlock Object ID

• 
  Hi Brian,
  
  You can resolve the object ID to an object name using
  SELECT object_name(72057598122328064)
  
  I hope this helps!

  Brian Donahue April 09, 2010 10:47

  - 0 +
• 
  When I try that I get the following error message
  
  Msg 8115, Level 16, State 2, Line 1
  Arithmetic overflow error converting expression to data type int.

  bwilkinson April 09, 2010 11:06

  - 0 +
• 
  Hi Brian,
  It looks like SQL Server has a bug. Please see this Microsoft article for a workaround.
  
  http://connect.microsoft.com/SQLServer/ ... g-deadlock

  Brian Donahue April 09, 2010 12:23

  - 0 +
• 
  That id looks more like the bigint field partition_id or hobt_id that you find in sys.partitions.
  
  Try ...
  
  select * from sys.partitions where partition_id = '72057598122328064'
  
  or
  select * from sys.partitions where hobt_id = '72057598122328064'
  
  this will then give you an object_id (int) that can be used with Object_name() to resolve

  kevriley April 12, 2010 06:35

  - 0 +

Add comment

Please sign in to leave a comment.