RE: Profiler showing no host data



P.S...same question for isql sessions, the traces I'm getting show isql/w as
the application but no host data, is this just the way it is..i.e. SQL Server
does not trap for or is not getting the host data for isql as well as the sql
query tool? Or is there some other setting/requirement for profiler to be
able to capture this?
thx

"bill_the_cat" wrote:

> I'm setting up profiler sessions to monitor various sql 2000 instances for
> logins, when testing with SQL Query Tool from my client box, the trace
> documents the login failure, but does not document the host name. However
> when testing using SQL Enterprise Manager it does document the client host
> name. What's the reason for this? Is there some setting I can change to
> capture this? Thx
.



Relevant Pages

  • Re: Add new cluster and use existing LUNs?
    ... Meta-volumes are dedicated to a single host, single activity (OS, swap file, ... varied activity (DBMSes, Messaging Server, File Server, Web Servers, ... Some of the physical spindle limitations can be addressed through the SAN ... >> test would be to run a simulated SQL I/O load on the newly created LUNs ...
    (microsoft.public.sqlserver.clustering)
  • Re: BizTalk Server 2006 - Running Host Instance consumes 100% CPU when "Allow Host Tracking" is
    ... the sql script needed to be run to install the ... BizTalk Server 2006 - Running Host Instance consumes 100% ...
    (microsoft.public.biztalk.general)
  • Re: Connect to table on web
    ... My web host already has mysql running on a linux box. ... Yes it is possible to connect to any sql server through the internet. ... Is your host on linux only or it has windows server as well. ...
    (borland.public.delphi.thirdpartytools.general)
  • Virtual PC connectivity Problem
    ... as a Virtual (guest) Machine, ... I have Windows XP as the host OS. ... I have installed SQL Server 2000 on the ... I have installed SQL Client utilities on the ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL and Majority Node Set
    ... MSCS requires each node to be on the same subnet. ... > on SQL Server installating in MS cluster 2k3 Majority", ... > evaluating some solutions to install SQL 2000 on Windows 2K3. ... > will be configured to not failover to the single host at the third site. ...
    (microsoft.public.sqlserver.clustering)