Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    12

    Unanswered: "Blank" Data Values in SQL Profiler

    I'm built a trace in SQL Profiler and I have selected columns "DatabaseName" and "Filename" (among others) to be displayed. When I run the trace, the columns are displayed but the values are blank. The SQLServer 2K version is 8.0.760. Is this a bug or am I missing something?

  2. #2
    Join Date
    Feb 2004
    Posts
    88
    Not all profiler data columns are populated for all events that can be captured.

    AFAICT "database name" will be populated for some events in the "security audit" catgory of events.

    In the "trace properties" box , on the "data columns" tab, press the help button.

    This should open up the BOL entry for "properties (data columns tab)"

    click on the "monitoring with SQL Profiler Event categories" link at the bottom of that help page, and you get to see which columns may be relevant to each trace event.

    Bill

  3. #3
    Join Date
    Mar 2004
    Posts
    12
    Thanks; the BOL tip is very helpful.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •