Re: Audit

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/18/02


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?.
>>>
>>
>>.
>>


Quantcast