Saturday, February 25, 2012

c2 audit ,about hostname coloum value

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

No comments:

Post a Comment