SQL Server Profiler missing templates

If you’ve upgraded to SQL Server 2008 R2 then you might have experienced a problem with your templates; they are gone!  You will also notice that your trace provider is now Microsoft SQL Server 10.50 and not Microsoft SQL Server 2008. This means different template folders and for some reason the templates are not always moved to the new 1050 folder from the old 100 folder, so what you have to do is this:

  • If you don’t have a 1050 folder, create on at C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server
  • Copy all the template files from C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\100
  • Paste them in your 1050 folder at C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\1050

Leave a Reply