snippetsqlMinor
How can I change the target server type for a trace template?
Viewed 0 times
canthetargettemplatetracetypeforhowserverchange
Problem
I've got a .tdf SQL Server Profiler trace template someone wants me to run but the template is targeting SS 2008 R2. While my SSMS is 2008 R2 the server I need to trace is SS 2005. When attempting to trace the server the server type is locked (generated from the actual server) so I can't just select the template I need while it's marked as a different SS version..
How can I change which server type the trade template is targeting? I've tried
How can I change which server type the trade template is targeting? I've tried
File > Templates > Edit Templates... but there doesn't seem to be an option to change this. Is it possible to change the target server version or does the whole trace have to be made again from scratch?Solution
I'm using Profiler 2012, talking to 2008, 2008 R2, and 2012 databases. I had to use a slightly different workflow than in the accepted answer.
When I try to follow that workflow, to migrate a template from 2008 to 2012, the Select template name dropdown depopulates, and clicking Save or Save As prompts me to choose a template to save.
Instead, copy your template from the 2012 profiler, 2008 templates folder (should be
Now, go to
At this point, you're pretty good - you can use the copied template to start traces. But if you want to make modifications on it, when you go to
To save it in the new format: start the trace running using
When I try to follow that workflow, to migrate a template from 2008 to 2012, the Select template name dropdown depopulates, and clicking Save or Save As prompts me to choose a template to save.
Instead, copy your template from the 2012 profiler, 2008 templates folder (should be
%APPDATA%\Microsoft\SQL Profiler\11.0\Templates\Microsoft SQL Server\100) to the 2012 profiler, 2012 templates folder (should be %APPDATA%\Microsoft\SQL Profiler\11.0\Templates\Microsoft SQL Server\110)Now, go to
File > New Trace... and choose the copied template to perform a trace on a 2012 server. Verify the trace is running and capturing what you want.At this point, you're pretty good - you can use the copied template to start traces. But if you want to make modifications on it, when you go to
File > Templates > Edit Template... and choose Events Selection you get a prompt indicating the trace is in the wrong format:To save it in the new format: start the trace running using
File > New Trace... as mentioned above, then with the trace running do File > Save As > Trace Template... and choose a new name. You can now delete the originally copied template, and use the newly saved template in its place.Context
StackExchange Database Administrators Q#23399, answer score: 6
Revisions (0)
No revisions yet.