Re: Audit
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/18/02
- Next message: lindawie: "Re: How can I deny user SA access to a Database?"
- Previous message: Gopal Ashok [MS]: "Re: Connectivity to SQL Server 2000 in Different Domain using SQL Login Failing"
- In reply to: Namir Rodriguez: "Re: Audit"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Tue, 18 Jun 2002 07:51:12 -0600
You can run a server-side trace instead of running Profiler.
You can use the sp_trace_xxx stored procedures for
server-side traces - books online has more info on these.
-Sue
On Tue, 18 Jun 2002 05:56:28 -0700, "Namir Rodriguez"
<Namir_Rodriguez@hotmail.com> wrote:
>But, I must have running profiler all time ?
>
>
>>-----Original Message-----
>>You can use Profiler and select the option to save to
>table.
>>You can also load/open a saved trace file in profiler and
>>save it to a table.
>>
>>-Sue
>>
>>On Mon, 17 Jun 2002 12:03:43 -0700, "Namir Rodriguez"
>><namir_rodriguez@hotmail.com> wrote:
>>
>>>Hi all!..
>>>
>>>I need to implement connection auditing in my SQL Server
>>>2000 server, but I want to write the audit events to a
>>>table, not in the Application Event Log. It can ben
>>>possible?.
>>>
>>
>>.
>>
- Next message: lindawie: "Re: How can I deny user SA access to a Database?"
- Previous message: Gopal Ashok [MS]: "Re: Connectivity to SQL Server 2000 in Different Domain using SQL Login Failing"
- In reply to: Namir Rodriguez: "Re: Audit"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]