SQL Server 2008R2 Profiler Templates not loaded when connected via SQL Server 2008

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.

Advertisements

7 Comments

  1. 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

  2. Anthony said,

    September 22, 2011 at 8:42 AM

    thank you it works for me. this is great.!!!!

  3. Stacey said,

    November 17, 2011 at 1:33 PM

    Thanks so much. It worked for me and saved me a lot of time!

  4. игрок 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

  5. Neil said,

    October 23, 2012 at 3:51 PM

    That’s what I was looking for. Thanks!

  6. April 25, 2013 at 6:50 PM

    It’s 2013, but your post still be usefull. Thanks a lot!

  7. 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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: