check which line is currently executing inside the sp in sql server :-

Step 1 :

SELECT   SPID       = er.session_id,

STATUS         = ses.STATUS,

[Login]        = ses.login_name,

Host           = ses.host_name,

BlkBy          = er.blocking_session_id,

DBName         = DB_Name(er.database_id),

CommandType    = er.command,

ObjectName     = OBJECT_NAME(st.objectid),

CPUTime        = er.cpu_time,

StartTime      = er.start_time,

TimeElapsed    = CAST(GETDATE() - er.start_time AS TIME),

SQLStatement   = st.text

FROM    sys.dm_exec_requests er

OUTER APPLY sys.dm_exec_sql_text(er.sql_handle) st

LEFT JOIN sys.dm_exec_sessions ses

ON ses.session_id = er.session_id

LEFT JOIN sys.dm_exec_connections con

ON con.session_id = ses.session_id

WHERE   st.text IS NOT NULL

Take SPID from above statement and paste into new the statement :

SELECT SUBSTRING(st.text, ( r.statement_start_offset / 2 ) + 1, 

( ( CASE WHEN r.statement_end_offset <= 0

THEN DATALENGTH(st.text) 

ELSE r.statement_end_offset END - 

r.statement_start_offset ) / 2 ) + 1) AS statement_text 

FROM   sys.dm_exec_requests r 

CROSS APPLY sys.dm_exec_sql_text(sql_handle) st 

WHERE  session_id = 57