SQL Server Performance Forum – Threads Archive

login failure trace not working in sql server 2000

Hello All,
I am trying to monitor login failures in SQL Server 2000 and YUKON. I could successfull implement a trace to monitor login failures in YUKON.
I am able to create a trace in 2000 but the trace is not getting updated by login failure information. The following commands are used used to create login failures trace. DECLARE @TraceIdOut int
Exec sp_trace_create @traceid= @TraceIdOut OUTPUT , @options = 2 ,@tracefile =N’c:logintrace’
select @TraceIdOut[TraceId] Declare @On bit
set @On =1
Exec sp_trace_setevent @traceid = @TraceIdOut ,@eventid = 20,@columnid =1, @on = @On
EXEC sp_trace_setstatus @traceid = @TraceIdOut, @status = 1 SELECT * FROM ::fn_trace_getinfo(DEFAULT) Thanks in advance.

Have you tried using PROFILER in SQL 2000 case? Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>