Recently when trying to trace few queries via SQL Server Profiler, I was surprised not seeing any templates loaded when starting new trace. After little work around I got root of solution.
We were using centralized SQL server 2008 R2.
While on each developer machine we guys were having SQL Server 2008 (not R2)
Simple workaround is open this directory in your LOCAL machine (NOT ON SERVER)
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server
You will see folders like 80, 90, 100
Just copy paste the 100 folder over same directory with new name 1050
and that’s it.
Now when you connect to your “SQL server 2008 R2” from your local “SQL Server 2008” in profiler you will see all templates loaded.