Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LB2809
Starting Member
2 Posts |
 Posted - 2011-08-18 : 13:22:12
|
| 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 |
|
|
gwilson67
Starting Member
42 Posts |
Posted - 2011-08-29 : 00:40:55
|
| How are you editing the template? Have you tried scripting out the original script and modifying the TSQL before creating the new template?Greghttp://www.freewebstore.org/tsqlcoderepositoryPowerful tool for SQL Server development |
 |
|
|
LB2809
Starting Member
2 Posts |
Posted - 2011-09-01 : 16:53:00
|
| Hi Greg,I was using the Profiler itself by selecting the 'Events' tab, not using scripts. But actually I am ok now, because I ran a trace in the R2 instance, saved it, and I can modify the Events now.Thanks,Larry |
|
|
|
|
|
|
Profiler template has the wrong format