SPID PROCESS SQL SERVER

View process in sql server

DECLARE @SPID INT ,@SQLScript NVARCHAR(max)

SELECT @SQLScript = CAST(TEXT AS NVARCHAR(max))
FROM sys.sysprocesses sp
CROSS APPLY sys.dm_exec_sql_text(sp.sql_handle)
WHERE sp.spid = @SPID

select @SQLScript

How to use :

1. Check running process from sp_who2, get sp_id
2. run scrib to view detail process running.

select * from [Sales].[Invoice.Vat.UpdateList] where convert(date,update_time)='2017-02-11'