SQL Profiler and Network Address (Mac ADDRESS)

25 Oct 2006 6:47 PM

Josh

Can profiler be setup to capture the clients MAC Address? If so how?

25 Oct 2006 7:09 PM

Arnie Rowland

I think that HOST_NAME is the best you can do with plain vanilla Profiler.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

Show quote

"Josh" <J***@discussions.microsoft.com> wrote in message
news:CF330DBD-671E-4005-8A03-800DE9E37546@microsoft.com...
> Can profiler be setup to capture the clients MAC Address? If so how?

25 Oct 2006 8:37 PM

Josh

Can you recommend any tools that would do this for us.

Show quote

"Arnie Rowland" wrote:

> I think that HOST_NAME is the best you can do with plain vanilla Profiler.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
>
> "Josh" <J***@discussions.microsoft.com> wrote in message
> news:CF330DBD-671E-4005-8A03-800DE9E37546@microsoft.com...
> > Can profiler be setup to capture the clients MAC Address? If so how?
>
>
>

25 Oct 2006 8:41 PM

Greg Linwood

Wireshark (previously known as Ethereal) can do this: www.wireshark.org

Best thing is that it's freeware..

Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood

Show quote

"Josh" <J***@discussions.microsoft.com> wrote in message
news:57F9C9BB-BF7A-45DA-8AF9-3168EC899347@microsoft.com...
> Can you recommend any tools that would do this for us.
>
> "Arnie Rowland" wrote:
>
>> I think that HOST_NAME is the best you can do with plain vanilla
>> Profiler.
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>>
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>>
>> You can't help someone get up a hill without getting a little closer to
>> the
>> top yourself.
>> - H. Norman Schwarzkopf
>>
>>
>> "Josh" <J***@discussions.microsoft.com> wrote in message
>> news:CF330DBD-671E-4005-8A03-800DE9E37546@microsoft.com...
>> > Can profiler be setup to capture the clients MAC Address? If so how?
>>
>>
>>