Or you can try something like the statement below:

  SELECT

   ss.is_user_process ,

   ss.session_id,

   ss.host_name, 

   ss.login_name,

   ss.nt_domain,

   ss.nt_user_name,

   ss.status,

   ss.total_elapsed_time,

   ss.reads,

   ss.writes,

   ss.logical_reads,

   ss.cpu_time as SessionCPU, -- CPU time, in milliseconds, that was used by this session.

   ss.row_count,

   ss.prev_error,

   (select m.text from sys.messages m...

Got it , thank you.

R

A combination between the 2 solution can do as well :>)

SELECT *

FROM

(

SELECT [PRODUCT_NAME],[PART_NUMBER],[Qty],

sum(case when Product_Name = 'BOM1' then isnull(Extended_Cost,0) else 0 end ) as Bom1Cost,

sum(case...

.. try something like this in your trigger:

select  SYSTEM_USER,HOST_NAME(),user_name(),SESSION_USER,