Hello!
Sorry for my English, but...
I'm using
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
    Dec 17 2002 14:22:05
    Copyright (c) 1988-2003 Microsoft Corporation
    Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
This code runs in Job when Agent starts
declare @p int, @b bit
set @b = 1
exec sp_trace_create @p output, 1, NULL, NULL, NULL
exec sp_trace_setevent @p, 107, 42, @b
exec sp_trace_setevent @p, 107, 11, @b
exec sp_trace_setevent @p, 107, 23, @b
exec sp_trace_setstatus @p, 1


while 1=1 begin
  insert into tempdb..ChangePasswordTraceTable(columnid, length, data) exec
sp_trace_getdata @p, 2
end

But either password was changed or was not (wrong old password) I have same 
value of data in row where columnid = 23 (success). Same problem when I try
to log sp_addlogin. Why I receive same value of success?

Using CASE in WHERE clause
Tempdb is growing and I can't tell what process is to blame
Beating a dead horse - Drop table from proc
Stored Procedure (Weird Question)
Sql Server Lock