Re: Auditing
From: Mark Allison (mark@allisonmitchell.c0m)
Date: 09/30/02
- Next message: Mark Allison: "Re: How SQL Server communicate with SQL server or applications"
- Previous message: Leon Parker: "Auditing"
- In reply to: Leon Parker: "Auditing"
- Next in thread: Steve: "Auditing"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Mark Allison" <mark@allisonmitchell.c0m> Date: Mon, 30 Sep 2002 19:30:20 +0100
You don't need profiler for this. Auditing can be turned on in Enterprise
Manager. Right click the server and then select the security tab. Set the
audit level as desired. Switching on profiler will give you extra
information, but consumes more server resources.
If you want to use profiler then create a stored procedure to start it and
mark it for startup using sp_procoption. Look at sp_trace_xxxxx stored
procedures in Books online.
-- Mark Allison http://www.allisonmitchell.com "Leon Parker" <lparker@lortobco.com> wrote in message news:bf5a01c268a2$5039ef80$37ef2ecf@TKMSFTNGXA13... > 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: How SQL Server communicate with SQL server or applications"
- Previous message: Leon Parker: "Auditing"
- In reply to: Leon Parker: "Auditing"
- Next in thread: Steve: "Auditing"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
