SQL 2000 & server side trace



I am using a server side trace to help track down why some data is
being deleted. One of the events that I'v included is #50 - SQL
Transaction (exp. begin, commit, save, etc..). My problem is that I'm
only getting notification of this event. I was hoping to be able to
capture some text in the 'TextData' column that I also included in the
server side trace. I'd like to know what type SQL Transaction commands
are being used.

Any ideas?

TIA

.



Relevant Pages

  • Re: Running profiler on busy 8-cpu Sql Server
    ... I always start with a light trace and add more detail as I go along to ... SQL Server MVP ... > I think it's also worth saying that you should introduce Profiler ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Repost - Unable to authenticate a VPN
    ... Thanks I did get the trace.. ... Microsoft Small Business Server Support ... >> the connection manager client.. ...
    (microsoft.public.windows.server.sbs)
  • Re: URGENT deadlock question
    ... > Profiler to view a trace, SQL Server dumps rowsets across the network to ... > SQL Server doesn't feel like it can keep up with all the activity. ... > server-side trace to a trace file guarantees you'll see everything. ...
    (microsoft.public.sqlserver.server)
  • RE: ProtocolError?
    ... If I just do a simple TCP trace I get: ... Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client ... WWW-Authenticate: Negotiate ... WWW-Authenticate header field that the Web server is not configured to accept. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: email disappearing
    ... Can you get a trace from an ISP that it does ... > Their webmail server likely has a different route to the other end then. ... > slightly different path again in NTL/TW but gets to the same router. ... Open a command window ...
    (uk.telecom.broadband)