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?
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)
