Re: profiler not showing transaction id / database name

z f wrote: 
on windows XP i have sql installed and profiler.
when using profiler to see the enterprise services (COM+) trnsaction,
no transaction ID is shown
and no database name is shown in the columns.
but there is a transaction (it even rolled back)

why?

TIA.

Certain columns are tied to certain events. Check BOL "Monitoring with SQL Profiler Event Categories" to see what columns are tied to events you are tracing. DatabaseName is not tied to many events, except Auditing events, if memory serves. Use the Database ID column instead. Transaction ID is tied to the transaction events (again, if memory serves).

--
David Gugick
Quest Software
www.imceda.com
www.quest.com 

.

Relevant Pages

  • Re: Help - Timing Logic
    ... server application, both of which ran on the same box. ... the client applications and 'lodging' them in the database. ... Another part of the server application was dedicated to retrieving messages ... commit transaction ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Auditing changes made to table design (syscolumns table)
    ... With out using profiler the only way I know of is to get this info from the ... Keep in mind I know the database and the tables I would ... I attempted to write a trigger to log when a change was made to the ... > certain criteria against every transaction. ...
    (microsoft.public.sqlserver.security)
  • Re: Help - Timing Logic
    ... put a trigger on the database table. ... Transaction and Database Locking - look at isolation levels / settings ... Maybe implement a message broker ... ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help - Timing Logic
    ... build a trigger on the database .. ... Transaction and Database Locking - look at isolation levels / settings ... If you need to implement a locking mechanism / or / logging mechanism / or / a checking mechanism to avoid duplicate messages caused by multi-threading ... ... message broker gets all the necessary messages or message id's from the database to be sent ... ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Help - Timing Logic
    ... put a trigger on the database table. ... Transaction and Database Locking - look at isolation levels / settings ... Maybe implement a message broker ... ...
    (microsoft.public.dotnet.languages.vb)
Quantcast