Thanks for pointing out I had these events sorted by type of event instead of event start time. I sorted them by event start time, so they make a little more sense... but still have some questions...
Event Class = Trace Start
---------------------------------------------------------------------------------------
What does this do?
Event Class = RPC: Completed
TextData = exec sp_unprepare 26
---------------------------------------------------------------------------------------
Does select @p1 actually execute the SQL statement or does it get the returned value of the sql statement?
Event Class = RPC: Completed
TextData = declare @p1 int
set @p1=26
exec sp_prepexec @p1 output,NULL,N'SELECT in_update FROM ngn_ids WHERE id_name = ''Histories_MedSurg'' AND id_value = ''557D78F4-F830-47C6-BE87-23F567F2FC3C'''
select @p1
---------------------------------------------
I don't understand the select @p1, @p3, @p4
It has executed the SQL, so @p1 stores the result of the SQL, right?
is select @p1, @p3, @p4 actually a select statement? if not what is it doing in that select line?
Event Class = RPC: Completed
TextData = declare @p1 int
set @p1=28
declare @p3 int
set @p3=0
declare @p4 varchar(max)
set @p4='ng_update_person: (Success), Person "Deano TestRochester" {557D78F4-F830-47C6-BE87-23F567F2FC3C} Added.'
exec sp_prepexecrpc @p1 output,N'ng_update_person',@po_result_code=@p3 output,@po_result_message=@p4 output,@pi_person_id='557D78F4-F830-47C6-BE87-23F567F2FC3C',@pi_user_id=154
select @p1, @p3, @p4
---------------------------------------------
What does this do?
Runs a select statement, but what for?
What does it do with the data selected?
Event Class = SQL: BatchCompleted
TextData = SELECT pe.enterprise_id, pe.practice_id, pe.person_id, pe.other_id_number, pe.first_name, pe.last_name, pe.middle_name, pa.person_id ,pa.med_rec_nbr, pe.date_of_birth, pe.sex, pe.nickname FROM { oj person pe LEFT OUTER JOIN patient pa ON pe.person_id = pa.person_id AND pa.practice_id = '0001' } WHERE pe.person_id = '557D78F4-F830-47C6-BE87-23F567F2FC3C'
_____________________________________