I have a SQL Trace that is running under the souce spid of 5s that is owned by "sa". I can't tell if this is something that is owned by SQL Server because of a setting, or is a process has called this and thus it is owned by sa rather than a named user.
09/16/2010 09:14:49,spid79,Unknown,SQL Trace stopped. Trace ID = '2'. Login Name = 'LIL\kevinl'.
09/16/2010 09:14:44,spid76,Unknown,SQL Trace ID 2 was started by login "LIL\kevinl".
09/08/2010 10:58:57,spid65,Unknown,SQL Trace stopped. Trace ID = '2'. Login Name = 'LIL\sladmin'.
09/08/2010 10:58:20,spid64,Unknown,SQL Trace ID 2 was started by login "LIL\sladmin".
[highlight=#ffff11]09/08/2010 10:55:46,spid5s,Unknown,SQL Trace ID 1 was started by login "sa".[/highlight]
I can see that the trace started and appears to still be running:
select * from fn_trace_getinfo(0)
Recnum TraceId property value
212C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_904.trc
Any assistance to a newb would be appreciated!