|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Wednesday, December 05, 2012 6:07 AM
Points: 35,
Visits: 230
|
|
sammesel is right, but this code should be corrected in the article. Please and thank you.
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Today @ 4:28 PM
Points: 39,
Visits: 229
|
|
I corrected the script in the article shortly after Sammesel brought this to my attention. As I mentioned in my other response, the other issue is that the script is intended for databases in 90 and later compatibility mode.
Thanks,
Dan
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Wednesday, December 05, 2012 6:07 AM
Points: 35,
Visits: 230
|
|
Hi Dan,
First, thanks for the article, it's been very helpful.
I saw your earlier reply regarding the versioning, and I should have been clearer. I was referring to the missing spaces in the FROM section, which should be corrected to:
FROM sys.traces AS t CROSS APPLY FN_TRACE_GETEVENTINFO(t.id) AS tdef JOIN sys.trace_events AS tevent ON tdef.eventid = tevent.trace_event_id JOIN sys.trace_categories AS tcat ON tcat.category_id = tevent.category_id JOIN sys.trace_columns AS tcolumn ON tcolumn.trace_column_id = tdef.columnid
It's simple to correct, but the original doesn't parse in SSMS as is.
Thanks for the quick response, Mike
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Today @ 4:28 PM
Points: 39,
Visits: 229
|
|
Thanks for pointing out the missing spaces in the script. The edit tool didn't preserve the original spaces so I added them back. The revision is awaiting appoval.
|
|
|
|