Can you please advise how I can fix this blocking?

Trigger1:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[DIM_BILL_INV_ITEM_GAD] ON [dbo].[DIM_BILL_INV_ITEM] FOR DELETE AS
SET NOCOUNT ON;

UPDATE l SET [ACTION_CODE] = 'D'

Thanks,

Here is the DDL script for the table DIM_BILL_INV_ITEM. Please advise.

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[DIM_BILL_INV_ITEM](
    [BILL_INV_ITEM_DID] [int] NOT NULL,
    [BILL_INV_ITEM_KEY] [varchar](100) NOT NULL,

I have used sp_WhoIsActive to find more info on blocking. Can you please advise what I can do to fix this blocking issue.
EXEC sp_WhoIsActive  @get_task_info = 2,  @get_additional_info =...

Session locks for SELECT query:

Here is my understanding of this deadlock. But I'm unable to get a solution to resolve this issue. Because of this, ETL load is failing and I have to re-run....

is there way to find concurrent users connecting to a particular database?

Hi Jeff and Ed,

I was able to get procedure name and its code (line 39). But my question is:

1. how to find what was running in SSMS using the login...

Thank you very much Jeff,

It's a vendor application and we don't own their code and the application update will happens through exe.

My main worry is to find out if something...

Thanks Jeff,

I was not running any queries in SSMS. We were running bunch of sql scripts which will do some updates (it's a vendor application, will get an .exe...