Require Logout Event Information



Hi,

I have a trace utility to trace login and logout event in SQL Server.
It is working fine. But I am getting one problem on it. Sometimes it
does not able to trace logout event. The possible case is when
accessing data through link server and open query.

Note: It can trace all login events.

Could anyone please explain why this is happening?

Thanks.

Karan

.



Relevant Pages

  • Re: One Web Service updates SQL, another cant?
    ... section of the Trace Properties dialog. ... And then I start getting the database closed errors on subsequent calls. ... > The error suggests that somehow the connection to SQL Server is being ... Could we have a look at your connection string? ...
    (microsoft.public.sqlserver.security)
  • Re: Profiler Security
    ... There's no way to restrict what a user of trace can see - if they ... etc. coming into SQL Server. ... >> want to assign the developers the sys admin sql role. ...
    (microsoft.public.sqlserver.security)
  • RE: Traces for Upgrade Advisor Tool SQL Server 2005?
    ... In SQL Server 2005, global trace flags set by a session take effect in other ... SQL Server 2005 introduces global and session level trace flags. ...
    (microsoft.public.sqlserver.tools)
  • Re: One Web Service updates SQL, another cant?
    ... Columnist, SQL Server Professional ... I guess its because this is my first Web Service and I ... it opens the database connection. ... See what that gives you in the trace. ...
    (microsoft.public.sqlserver.security)
  • Re: Best Practices for Auditing
    ... > question to you all is, since we want to also audit the ... > trace, removing records from the trace, etc.) ... SQL Server there is no way to stop members of the System ... auditing data, for example if you use a sproc to return ...
    (microsoft.public.sqlserver.security)