here's the answer (really simple question):

INSERT INTO #INPUTBUFFER_SRC EXEC('DBCC INPUTBUFFER(' + @SPID + ')')

THANK YOU.

but what if I want to pass parameters to stored procedures?

Dear AJ Ahrens,

I didn't get what exactly u mean, can u give me more explanation please?

sounds complicated. specially if i am gonna use it in many tables..

fortunately for me, the first answer is suffecient for me now.

thank you all

sounds complicated. specially if i am gonna use it in many tables..

fortunately for me, the first answer is suffecient for me now.

thank you all

really thank you (specially jesper)

but because I am greedy, is there a way to make it more dynamic. I mean if I didn't even know the types (in this case...

no I didn't get a solution..

I had to use the trigger method.

So, We must modify the DB which what what my manager tried to avoid.

however, thank you all because you made...

thank you all

or i can explain it clearer in the following way:

I have a table without auto-generated ID nor time stamp.

I want to identify the newly inserted rows in a table.

I can't...

thank you Ian

this's exactly what I was looking for