A New Default Profiler Template
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.