SQL Profiler help needed

From: Ashwin (Ashwin_Karavadi@satyam.com)
Date: 07/17/02 

From: "Ashwin" <Ashwin_Karavadi@satyam.com>
Date: Tue, 16 Jul 2002 15:53:04 -0700

Hi,

I am using SQL Profiler to track the people who log in to
the database. I created a trace file to capture the
events "Session" and "T-SQL" and ran it on one of our
servers..it worked fine and it captured the NT user IDs of
the people who logged into the server.
However when I created the same trace on another server
the NT User IDs are not captured(only blanks are displayed
in that column).
Could anyone here please let me know why this is
happening??Do I have to install any SQL Server patches??

Thanks in advance

Ashwin

Relevant Pages

  • RE: Procedure last accessed
    ... you could use SQL Profiler ... to capture this information and write it to a table on the same server or ... another server. ... This posting is provided AS IS with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: Pivot Tables and AS2005 Dimension Security
    ... SQL Profiler on the AS 2005 server, to capture the MDX query and test it ... Microsoft MVP - SQL Server ...
    (microsoft.public.sqlserver.olap)
  • Re: SQL Profiler - Reads and Writes
    ... the SQL Profiler does not ... > capture any reads and writes from one of the development servers, ... > to that server. ... The values are collected by the server, not the client. ...
    (microsoft.public.sqlserver.server)
  • RE: error 17805; invalid buffer received from client
    ... when I just want to capture the event that is causing this. ... "Peter The Spate" wrote: ... When I run sql profiler to only capture this ...
    (microsoft.public.sqlserver.server)
  • Re: Replay Trace Profiler files with T-SQL code
    ... If you want your replay to be realistic, ... the applicaiton semantics that just can't be captured in a SQL trace file. ... have not found any of the exisiting generic tools to provide any realism at ... Replaying trace files is a function of the SQL Profiler application, ...
    (microsoft.public.sqlserver.programming)