text: USE [Demo Database NAV ITA (11-0)]
  GO
  
  /****** Object:  View [dbo].[V_Deadlocks_]    Script Date: 11/04/2018 22:09:13 ******/
  SET ANSI_NULLS ON
  GO
  
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE VIEW [dbo].[V_Deadlocks_]
  AS
  SELECT DTL.resource_type,  
     CASE   
         WHEN DTL.resource_type IN ('DATABASE', 'FILE', 'METADATA') THEN DTL.resource_type  
         WHEN DTL.resource_type = 'OBJECT' THEN OBJECT_NAME(DTL.resource_associated_entity_id)  
         WHEN DTL.resource_type IN ('KEY', 'PAGE', 'RID') THEN   
             (  
             SELECT OBJECT_NAME([object_id])  
             FROM sys.partitions  
             WHERE sys.partitions.hobt_id =   
             DTL.resource_associated_entity_id  
             )  
         ELSE 'Unidentified'  
     END AS requested_object_name, DTL.request_mode, DTL.request_status,    
     DOWT.wait_duration_ms, DOWT.wait_type, DOWT.session_id AS [blocked_session_id],  
     sp_blocked.[loginame] AS [blocked_user], DEST_blocked.[text] AS [blocked_command], 
     DOWT.blocking_session_id, sp_blocking.[loginame] AS [blocking_user],  
     DEST_blocking.[text] AS [blocking_command], DOWT.resource_description     
  FROM sys.dm_tran_locks DTL  
     INNER JOIN sys.dm_os_waiting_tasks DOWT   
         ON DTL.lock_owner_address = DOWT.resource_address   
     INNER JOIN sys.sysprocesses sp_blocked  
         ON DOWT.[session_id] = sp_blocked.[spid] 
     INNER JOIN sys.sysprocesses sp_blocking  
         ON DOWT.[blocking_session_id] = sp_blocking.[spid] 
     CROSS APPLY sys.[dm_exec_sql_text](sp_blocked.[sql_handle]) AS DEST_blocked 
     CROSS APPLY sys.[dm_exec_sql_text](sp_blocking.[sql_handle]) AS DEST_blocking 
  WHERE DTL.[resource_database_id] = DB_ID()
  
  GO
  
  EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
  Begin DesignProperties = 
     Begin PaneConfigurations = 
        Begin PaneConfiguration = 0
           NumPanes = 4
           Configuration = "(H (1[29] 4[19] 2[24] 3) )"
        End
        Begin PaneConfiguration = 1
           NumPanes = 3
           Configuration = "(H (1 [50] 4 [25] 3))"
        End
        Begin PaneConfiguration = 2
           NumPanes = 3
           Configuration = "(H (1 [50] 2 [25] 3))"
        End
        Begin PaneConfiguration = 3
           NumPanes = 3
           Configuration = "(H (4 [30] 2 [40] 3))"
        End
        Begin PaneConfiguration = 4
           NumPanes = 2
           Configuration = "(H (1 [56] 3))"
        End
        Begin PaneConfiguration = 5
           NumPanes = 2
           Configuration = "(H (2 [66] 3))"
        End
        Begin PaneConfiguration = 6
           NumPanes = 2
           Configuration = "(H (4 [50] 3))"
        End
        Begin PaneConfiguration = 7
           NumPanes = 1
           Configuration = "(V (3))"
        End
        Begin PaneConfiguration = 8
           NumPanes = 3
           Configuration = "(H (1[56] 4[18] 2) )"
        End
        Begin PaneConfiguration = 9
           NumPanes = 2
           Configuration = "(H (1 [75] 4))"
        End
        Begin PaneConfiguration = 10
           NumPanes = 2
           Configuration = "(H (1[66] 2) )"
        End
        Begin PaneConfiguration = 11
           NumPanes = 2
           Configuration = "(H (4 [60] 2))"
        End
        Begin PaneConfiguration = 12
           NumPanes = 1
           Configuration = "(H (1) )"
        End
        Begin PaneConfiguration = 13
           NumPanes = 1
           Configuration = "(V (4))"
        End
        Begin PaneConfiguration = 14
           NumPanes = 1
           Configuration = "(V (2))"
        End
        ActivePaneConfig = 0
     End
     Begin DiagramPane = 
        Begin Origin = 
           Top = 0
           Left = 0
        End
        Begin Tables = 
        End
     End
     Begin SQLPane = 
     End
     Begin DataPane = 
        Begin ParameterDefaults = ""
        End
        Begin ColumnWidths = 14
           Width = 284
           Width = 1065
           Width = 2655
           Width = 795
           Width = 1230
           Width = 1500
           Width = 1500
           Width = 1500
           Width = 1500
           Width = 1335
           Width = 1500
           Width = 1500
           Width = 1500
           Width = 1500
        End
     End
     Begin CriteriaPane = 
        Begin ColumnWidths = 11
           Column = 1440
           Alias = 900
           Table = 1170
           Output = 720
           Append = 1400
           NewValue = 1170
           SortType = 1350
           SortOrder = 1410
           GroupBy = 1350
           Filter = 1350
           Or = 1350
           Or = 1350
           Or = 1350
        End
     End
  End
  ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'V_Deadlocks_'
  GO
  
  EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'V_Deadlocks_'
  GO
  
  