Just a quick note if you run profiler on a SQL 2008 machine and fine there are no templates then thats possibly because you have run the SQL 2005 version of profiler, this version of profiler doesn't read the SQL 2008 templates. There are a different set of templates for each version of database you can connect to. They are stored in C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates on an x64 box and in C:\Program Files\Microsoft SQL Server\100\Tools\Profiler\Templates on an x86 box.
You will see folders for 80, 90 and 100 (SQL 2000, 2005 and 2008 respectively).
So in summary make sure you run Profiler.exe and not profiler90.exe. The latter is the SQL2005 version of profiler.
-
Source Click Here.
Post a Comment