Auditing

From: Leon Parker (lparker@lortobco.com)
Date: 09/30/02

Next message: Mark Allison: "Re: Auditing"
Previous message: mp: "How SQL Server communicate with SQL server or applications"
Next in thread: Mark Allison: "Re: Auditing"
Reply: Mark Allison: "Re: Auditing"
Reply: Steve: "Auditing"
Reply: Sue Hoegemeier: "Re: Auditing"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

From: "Leon Parker" <lparker@lortobco.com>
Date: Mon, 30 Sep 2002 09:56:25 -0700

I'm trying to create auditing to track user logon/logoff.
How do I use system stored procedures or Profiler to
create the trace and have it to start automatically
whenever SQL starts?

Next message: Mark Allison: "Re: Auditing"
Previous message: mp: "How SQL Server communicate with SQL server or applications"
Next in thread: Mark Allison: "Re: Auditing"
Reply: Mark Allison: "Re: Auditing"
Reply: Steve: "Auditing"
Reply: Sue Hoegemeier: "Re: Auditing"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: Profiler Bug viewing trace flat file?
... The TextData column is definitely populated when I query resulting trace ... selected in Profiler and run from Profiler. ... declare @TraceID int ...
(microsoft.public.sqlserver.tools)
Re: Profiler Bug viewing trace flat file?
... exec PostAvailableContractsCache_sp ... The TextData column is definitely populated when I query resulting trace ... selected in Profiler and run from Profiler. ...
(microsoft.public.sqlserver.tools)
Re: Application Trace Profiler
... I have my debug event handling loop in a background thread, ... I tried this article and I was able to profile the Trace messages from my ... there any way to detach from the application so that the profiler can exit ... intercept the Trace statements of another running .NET application. ...
(microsoft.public.dotnet.general)
Re: Profiler temp file
... Yes you are missing the whole point. ... Trace to a file without running profiler at all. ... shows how to create a script from scratch but if you follow my instructions ...
(microsoft.public.sqlserver.tools)
Re: Application Trace Profiler
... I have my debug event handling loop in a background thread, ... I tried this article and I was able to profile the Trace messages from my ... there any way to detach from the application so that the profiler can exit ... intercept the Trace statements of another running .NET application. ...
(microsoft.public.dotnet.general)