I had a similar problem after moving a database from D drive to E drive using detach and attach process. It turns out to be a permission issue on the...

Thanks Dan. The updated query now returns the full resultset.

I copied the script used to list all possible trace events and columns and executed on my sql server 2005 SP3 system. It returns only 14 rows (in other words...