A New Default Profiler Template

Published 03 June 12 08:54 PM | MartinBell

The other week I wrote a post about Changing Server Side Traces and commented on the Default Profiler Trace template having unused variables which I have raised a a bug on connect. I checked this again and was very disappointed to find they had already closed it as “won’t fix”. I know SQL Trace is being deprecated so there is limited life for it, but if this was my code I would have corrected it just because of the embarrassment and the pride I have in producing quality code. Well that is not quite true; if that was my code I would hope it wouldn’t make version control in that form.

I have subsequently taken the two minutes to correct the issue and attached a new Default Profiler Trace template to the connect item. You can find it here. When you first open Template Explorer the template files are put into your

C:\Users\<UserName>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates\Sql\SQL Trace

directory. If your replace the existing “Default Profiler Trace.sql” file with the attached version, you can then use it from Template Explorer.

Filed under: ,


No Comments

This Blog

SQL Blogs