March 24, 2008 at 11:49 am
I set up a profiler including databasename and error columns, but those 2 columns are empty (no entry). What is event/column name to have these 2 columns filled? I do not want to make the trace file too big.
Any advice?
March 24, 2008 at 12:32 pm
I never saw databasename filled-in in SQL2000, use DBID instead. Error code is only filled in for error events.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 24, 2008 at 1:51 pm
Thank you. Wondering why databasename is there but does not really work, or if it does not work why need to be there.
March 24, 2008 at 1:55 pm
I've wondered the same thing for 7 years. Let me know if you find out.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply