Re: c2 audit ,about hostname coloum value

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/30/04

  • Next message: lars: "RE: SQL Server View needs permission on underlying tabel" 
    Date: Wed, 30 Jun 2004 10:14:08 +0530

    HI,

    There is no data column named Host IP address in profiler, as well as you
    cant change the
    data columns for C2 Audit option.

    Can I change the audit's file to another directory ?

    No, you cant change the directory. 

    --
Thanks
Hari
MCDBA
"william.huang" <william.huang@saturn.yzu.edu.tw> wrote in message
news:OBTku6kXEHA.2972@TK2MSFTNGP12.phx.gbl...
> Hi!
>   When the audit mode is set to 1 and reconfigured ,
>   Sql Profiler can read audit file which have a colum called HostName
record
> the computer name of  source Computer.  How can I change this vaue to the
> source computer's IP address.
> And Can I change the audit's file to another directory ?
> thanks  .
>
>
  • Next message: lars: "RE: SQL Server View needs permission on underlying tabel"

    Relevant Pages

    • Re: How to know which tables is updated ?
      ... You could use profiler to audit certain types of activity & subsequently see what activity has occured through time. ... You could use triggers &/or default values to maintain a list of who & when records are added. ... is there any utility in Sql Server 2000 or any kind of third party tool available? ...
      (microsoft.public.sqlserver.server)
    • Re: audit
      ... If you want a subset of what you get with C2 auditing, ... can create a SQL Profiler trace that will capture what you ... available to you when using Profiler. ... Audit event classes when defining a trace in Profiler. ...
      (microsoft.public.sqlserver.security)
    • Frage zu SQL Profiler
      ... Verbindung zum MSSQL-Server her und schließe diese gleich wieder über ... Dieses habe ich mir mit dem Profiler mal angesehen und es ergibt sich für ... warum beim Aufruf der Verbindung im Profiler "Audit Login ... "Audit Logout ...". ...
      (microsoft.public.de.sqlserver)