Require Logout Event Information
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? ...
- Re: Track deadlocks and locks that take too long
... I looked at the trace definition in your example code and it had the value 2 which means just that. ... Tibor Karaszi, SQL Server MVP ... As long as you tell it to on the General page of the profiler. ... declare @TraceID int ...
- RE: cannot delete a record in sql server 2005 through asp program
... Using trace script he provided and trace file created by the script. ... SQL Server database by the asp application. ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
- 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. ...
- Re: Auditing sql server at runtime
... "Manpreet Singh" wrote in message ... DB Dev SQL Server 2005 ... Use SQL Profiler to define your trace, ... Create a SQL Agent job to run that trace, ...