How to capture object sender in sql server

%3CLINGO-SUB%20id%3D%22lingo-sub-1611565%22%20slang%3D%22es-ES%22%3EHow%20to%20capture%20object%20sender%20in%20sql%20server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1611565%22%20slang%3D%22es-ES%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20which%20is%20updated%20from%20many%20stored%20procedures%2C%20jobs.%20I%20want%20to%20capture%20the%20SP%20name%20once%20this%20table%20is%20updated.%20Is%20the%20any%20variable%20I%20can%20use%20in%20a%20trigger%2FSP%3F%26nbsp%3B%20Another%20way%20to%20do%20it%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

I have a table which is updated from many stored procedures, jobs. I want to capture the SP name once this table is updated. Is the any variable I can use in a trigger/SP?  another way to do it?  

0 Replies