Re: Audit

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


From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 17 Jun 2002 14:02:56 -0600


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



Relevant Pages

  • Re: Audit
    ... I must have running profiler all time? ... >>I need to implement connection auditing in my SQL Server ... but I want to write the audit events to a ...
    (microsoft.public.sqlserver.security)
  • Re: Problem altering table and adding a default
    ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... with SQL Server. ... Not only does the Profiler GUI's screen need to ... Server & places it on queues that the Profiler GUI picks up. ... / data columns & filters you define in a profiler trace, ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... ALTER TABLE dbo.Test_tbl ADD Notnull_col1 charNOT NULL ... SQL Server does not allow that - you can only add nullable columns. ... After you add a new column in Enterprise Manager, uncheck Allow Nulls, bind the uder- ... Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: stress by profiler ?
    ... Are you running the Profiler on the same machine as SQL Server? ... The response time of DB access is also good. ... -- very low Disk Read ...
    (microsoft.public.sqlserver.server)