• cdl_9009 (10/18/2013)


    This may not fit this category.

    Does anybody know how to create a template in SQL Profiler 2008r2 that would allow you to use that on a 2012 server?

    I Profiler can trace what I am doing in the software which is on 2012 but I won't let me save my template to use it again. I have to continually change the settings.

    Create a profiler trace on the 2008R2 machine. Export the trace as a TSQL script and run that script on the 2012 server. You shouldn't have any problems.

    In essence you would be creating a server-side trace and using it on another server.