SQL - Saber que se esta ejecutando en BD desde APP.

DECLARE @BD VARCHAR(100)

--SET @BD = 'leasecom'

SET @BD = 'leaseoper'

select b.name, a.last_execution_time

from sys.dm_exec_procedure_stats a

inner join sys.objects b on a.object_id = b.object_id

where DB_NAME(a.database_ID) = LTRIM(RTRIM(@BD))

ORDER BY 2 DESC