Asked By srinivasan
21-Jan-10 03:18 AM
Hi
I am using the set trace to create the trace file for set of events defined
in the script.
also i set the max size of each trace file fixed at 30 MB. So after reaching
30 MB, another file is automatically created and logs are stored in it.
the script is given below.
-- Create a Queue
declare @rc int
declare @TraceID int
declare @maxfilesize bigint
set @maxfilesize = 30
exec @rc = sp_trace_create @TraceID output, 2, N'D:\Projects\NEA-HP\DBA
Tasks\ises_audit_01', @maxfilesize, NULL
Then i am using the
the problem is last week i got one event recorded as Audit Login failed.
I cannot find any information regarding this event except the time.
How to get the windows user id or ip address of the machine from where this
log is triggered