ProcID lineage identification
I am working with SQL Server 2008 and need for stored proc B to be able to give (whether that means storeor print etc...) the name/id of stored proc A which called it. I.e. I would like to find the value of the parent of @@ProcID.

I have seen the question has been asked but not given a satisfactory answer (from Microsoft or any online community) so I thought there would be a clevr solution using sp_who in combination with master..sysprocesses but I haven't come up with one.
ProcID lineage identification
===

I am working with SQL Server 2008 and need for stored proc B to be able to give (whether that means storeor print etc...) the name/id of stored proc A which called it. I.e. I would like to find the value of the parent of @@ProcID.

I have seen the question has been asked but not given a satisfactory answer (from Microsoft or any online community) so I thought there would be a clevr solution using sp_who in combination with master..sysprocesses but I haven't come up with one.