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?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|||Thanks; the BOL tip is very helpful.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment