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.
Larry said,
August 18, 2011 at 9:55 PM
Hello,
I created the new 1050 folder and copied in the contents of the 100 folder.
But when I try to create a new template based on an existing one, I get ‘Template C:\Program Files\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\1050\TSQL_Duration.tdf has the wrong format. Do you want to delete this template?’
How can I rectify this?
Thanks,
Larry
Anthony said,
September 22, 2011 at 8:42 AM
thank you it works for me. this is great.!!!!
Stacey said,
November 17, 2011 at 1:33 PM
Thanks so much. It worked for me and saved me a lot of time!
игрок said,
January 28, 2012 at 1:30 AM
I simply could not go away your site prior to suggesting that I really enjoyed the usual information a person supply for your guests? Is gonna be back ceaselessly in order to check up on new posts
Neil said,
October 23, 2012 at 3:51 PM
That’s what I was looking for. Thanks!
Daiana Sodré said,
April 25, 2013 at 6:50 PM
It’s 2013, but your post still be usefull. Thanks a lot!
Martin Smith (@martinsmith_) said,
May 16, 2013 at 3:45 PM
This didn’t work for me. I copied the files from the folder C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler on the Server to the same directory on my local machine then it worked.