Profiler templates showing blank for sql 2019 version from SQL 2014 profiler

Question

Iam connecting sql 2019 instance from sql 2014 profiler to setup a trace but templates showing as blank .

Answer 1

Hi @Santhosh kumar

By default, SQL Server Profiler templates are stored here:

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server

Within this folder, you will see sub-folders for different SQL Server versions (80,90,100,1050). It could be that you are trying to connect your profiler to a server running a higher release.

In the case of the profiler from SQL 2008 connecting to a SQL 2008 R2 instance, copy the 100 profile templates folder (default install is at C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\100) into a new folder in the same location with the name “1050” i.e. C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\1050.

More information about SQL versions can be found at: Microsoft SQL Server Versions List.

Referring from this blog: SQL Profiler templates missing.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The simplest way is to download and install SQL Server Management Studio 19. This will give you Profiler and templates for all versions up to SQL 2022.

Copying templates from earlier versions as Cosmog suggests should work, I think, but I've never tried it myself.

Answer 3

For Example; if you are working on Client Server and you don't have access to create folder or copy the items due to security reasons. In such case take the profiler on your local machine and then stop it and save the trace file on your local. Then Copy the Trace on your server desktop and open it and click on new Trace and then you be able to see TSQL_SP's and other options under use the template.