Mysterious Insert not appearing in Trace

[whool]

I am trying to find out how a client is inserting a row into a particular table in a SQLSvr2000 database. I have run a trace on SQL profiler while performing the insert operation from the Client interface (via a browser).I have set the trace to look for RPCCompleted and SQLBatchcompleted events. Yet the trace shows no batches with insert statements, neither does it find any SPs that can insert records into the concerned table. There are RPCs to sp_cursorfetch and sp_cursorclose - admittedly I don't know exactly how they fit into to picture - but I dont see how they can relate directly to an insert. (I mean a cursor isn't used for inserts but rather for Selects and updates)

I had thought that any insert into a table must be by way of either a Batch or a stored procedure but it seems there is a phantom event at work somewhere...

Any help with this mystery much appreciated.

Yael

 

[skicamel]

My experience is limited, but try one of the sample traces in Profiler: TSQL & Stored Procedures, or just plain TSQL. Let me know if this picks it up.