为什么我的SQL服务器探查器只显示我空白模板

I am new to this SQL server profiler stuff. I am trying to create a trace in sql server profiler. when i tried to select the template it is showing me only blank and no name of template can anyone tell me why

我是这个SQL服务器探查器的新手。我想在sql server profiler中创建一个跟踪。当我试图选择模板时,它只显示空白,没有模板名称,任何人都可以告诉我原因

1 个解决方案

#1

By default, SQL Server Profiler templates are stored here:

默认情况下,SQL Server Profiler模板存储在此处:

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.

在此文件夹中,您将看到不同SQL Server版本的子文件夹(80,90,100,1050)。可能是您尝试将分析器连接到运行更高版本的服务器。

Check this: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/b5a0c106-faf6-4a21-a012-2d60366190e3/

请查看:http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/b5a0c106-faf6-4a21-a012-2d60366190e3/

"The server you are connecting to is a 10.50 sql server and your machine doesnt have a folder for that. So to fix it, copy your 100 folder (found: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\100) making a new folder in the same location named 1050."

“你连接的服务器是10.50 sql服务器,你的机器没有一个文件夹。所以要修复它,复制你的100文件夹(找到:C:\ Program Files(x86)\ Microsoft SQL Server \ 100 \ Tools \ Profiler \ Templates \ Microsoft SQL Server \ 100)在名为1050的同一位置创建一个新文件夹。“

#1