question

LB2809 avatar image
LB2809 asked

Profiler template has the wrong format

Hi, I would like to create a new SQL Server Profiler template based on an existing template. Since I'll be connecting to 2008 R2, I had to create C:\\Program Files\\Microsoft SQL Server\\100\\Tools\\Profiler\\Templates\\Microsoft SQL Server\\1050 on my PC and copy in the contents of folder \\100. But when I try to create a new template based on an existing template such as TSQL_Duration, and click on the Events tab, I get "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?" Has anyone else encountered this problem? Thanks, Larry
profiler
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jason Crider avatar image
Jason Crider answered
Hi Larry, You say that you are connecting to 2008 R2, correct? What version is on your box?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

LB2809 avatar image
LB2809 answered
Hi Jason, Select @@version gives me Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) (Hypervisor) Thanks for responding. I am new to SQL server; I've just switched over from PeopleSoft/Oracle after 12 years. Larry
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Entering that command from within SSMS will give you the version of the instance you are connected to, not the version of SQL tools running on your PC. If you go to help and about on your PC what edition of SSMS does it show you have? I think the same box can be seen doing Help/About in profiler too.
0 Likes 0 ·
Hi meltonda, When I do Help / About on my PC, I get Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 ) So, I guess this means I have SQL Server 2008 on my PC, but I'm trying to use SQL Profiler to monitor a 2008 R2 db. IS it ok to do this? I still have to check Jason's link. Thanks, Larry
0 Likes 0 ·
I would not see why it should be a big deal. You might try patching SQL Server 2008 on your PC. They released SP2 on Aug 4, or you could apply SP1. SP2 can be found here: http://www.microsoft.com/download/en/details.aspx?id=12548
0 Likes 0 ·
Jason Crider avatar image
Jason Crider answered
Larry, I've had problems in the past when I tried to open a newer template in an older version. Start looking here ([ http://msdn.microsoft.com/en-us/library/ms188303.aspx][1]) and see what you can find. [1]: http://msdn.microsoft.com/en-us/library/ms188303.aspx
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ok Thanks Jason!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.