I'm using SQL Server 2000 Profiler to monitor several
applications, and I don't understand why I'm not seeing data for
some of the events that I've requested traces for. For example,
my trace includes the RPC:Completed event (from the Stored
Procedures event class), and I should be seeing values for the
ObjectId data column. The trace runs, but I don't see any values
for the ObjectId data column associated with the RPC:Completed
event. Why are many of the data columns I've selected empty for
some of the events I've captured?  The short answer to your
question is that Profiler doesn't capture ObjectId for the
RPC:Completed event. The Profiler GUI doesn't explain this
quirk, but a one-to-one match doesn't exist between all Profiler
events and data columns. Thus, Profiler doesn't capture every
data column for every event. For a good description of which
data columns Profiler populates for which events, see the SQL
Server Books Online (BOL) topic "Monitoring with SQL Profiler
Event Categories." This BOL topic als