Frage zu SQL Profiler

From: Brian Schmalisch (arcon-media_at_gmx.net)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 09:43:28 +0200

Hallo,

aus einer C# Anwendung heraus stelle ich mit Connection Open() eine
Verbindung zum MSSQL-Server her und schließe diese gleich wieder über
Close().

Dieses habe ich mir mit dem Profiler mal angesehen und es ergibt sich für
mich die Frage, warum beim Aufruf der Verbindung im Profiler "Audit Login
..." steht, beim durchlaufen der Close-Methode wird jedoch nichts
protokolliert. Erst nach Beenden der kompletten Anwendung bekomme ich ein
"Audit Logout ...".

Ist das so OK?

mfg
Brian

Relevant Pages

  • Re: Try Catch Finally
    ... The sp_reset_connection stored procedure is used by SQL Server to support remote stored procedure calls in a transaction. ... This stored procedure also causes Audit Login and Audit Logout events to fire when a connection is reused from a connection pool. ...
    (microsoft.public.de.german.entwickler.dotnet.vb)
  • Re: How to know which tables is updated ?
    ... You could use profiler to audit certain types of activity & subsequently see what activity has occured through time. ... You could use triggers &/or default values to maintain a list of who & when records are added. ... is there any utility in Sql Server 2000 or any kind of third party tool available? ...
    (microsoft.public.sqlserver.server)
  • Re: c2 audit ,about hostname coloum value
    ... There is no data column named Host IP address in profiler, ... data columns for C2 Audit option. ... you cant change the directory. ... > Sql Profiler can read audit file which have a colum called HostName record> the computer name of source Computer. ...
    (microsoft.public.sqlserver.security)
  • Re: audit
    ... If you want a subset of what you get with C2 auditing, ... can create a SQL Profiler trace that will capture what you ... available to you when using Profiler. ... Audit event classes when defining a trace in Profiler. ...
    (microsoft.public.sqlserver.security)