Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SQL Server 2008 Profiler--Templates Missing

Answered SQL Server 2008 Profiler--Templates Missing

  • Tuesday, November 18, 2008 12:42 AM
    Moderator
     
     
    Sign In to Vote
    0

     

    For some reason (even after an uninstall, reinstall and updating the the Community Update) there are no templates visible in the Profiler for SQL Server 2008. On another system it works fine but the Trace Provider Type shows "Microsoft SQL Server 2008". On the problem system it shows "Microsoft SQL Server 10.0".

     

    What's up?

     

     

All Replies

  • Wednesday, November 19, 2008 5:03 AM
     
     
    Sign In to Vote
    0

    A copy of the templates should live under "Documents and Settings" folder in "Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\Templates". Check if that's the case or not.

     

    Thanks,

    Varsham

     
  • Wednesday, November 19, 2008 7:17 AM
     
     
    Sign In to Vote
    0

     

    Check the following path:

     

    C:\Program Files\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\100

     

    It contains the available templates for SQL Server 2008.

     

    Thanks

    Sreekar

     
  • Friday, November 21, 2008 9:07 AM
     
     Answered
    Sign In to Vote
    0

     

    Hello William

     

    It seems to be a known issue in case of SQL Server 2008 . Already a defect is raised for it.

    Please check this link

     

    http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=382515

     


    Thanks

    Sreekar

     
  • Friday, November 21, 2008 2:09 PM
     
     Answered
    Sign In to Vote
    0
    Copy the folder from another SQL Server to your machine, the default path is C:\Program Files\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\100,  Any question, let me know.

     

     
  • Monday, December 15, 2008 12:45 PM
     
     
    Sign In to Vote
    0

    Could it be that you accidentally ran the SQL 2005 version of profiler. I did and got exactly that behaviour.

    Missing Profiler Templates in SQL 2008

     

    SQL Server MVP http:\\sqlblogcasts.com\blogs\simons
     
  • Tuesday, September 14, 2010 7:30 PM
     
     Answered
    Sign In to Vote
    12
    For some reason (even after an uninstall, reinstall and updating the the Community Update) there are no templates visible in the Profiler for SQL Server 2008. On another system it works fine but the Trace Provider Type shows "Microsoft SQL Server 2008". On the problem system it shows "Microsoft SQL Server 10.0".

     

    What's up?

    Here is the actual answer you were all looking for:

    The server you are connecting to is a 10.50 sql server and your machine doesnt have a folder for that. So to fix it, copy your 100 folder (found: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\100) making a new folder in the same location named 1050.

    Everything will work fine now.

     

     
  • Wednesday, December 29, 2010 4:39 PM
     
     
    Sign In to Vote
    0

    Chris I tried that. I even made a C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Profiler\Templates\Microsoft SQL Server\10501600 (10.50.1600 is the version of the server I am connecting to) folder as well as the 1050 folder. However neither one worked. My SQL Profiler does not show any other template than "Blank".

    Side note: I ran SysInternals procmon, and I do not even see the profiler attempting to access any of the template directorties. It does however access:

    HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\SQLServerProfiler\Client\Templates\Microsoft SQL Server\100

    //Will write code for food
     
  • Monday, August 22, 2011 10:53 PM
     
     
    Sign In to Vote
    0
    Thanks @ChrisLawrence that worked PERFECTLY!
     
  • Friday, January 27, 2012 2:46 PM
     
     
    Sign In to Vote
    0
    My thanks also to @ChrisLawrence - it worked perfectly and saved me from more aggrevation trying to locate templates I'd thought I'd created.
     
  • Thursday, July 12, 2012 9:44 PM
     
     
    Sign In to Vote
    0
    This solution does not work for me. I've even tried copying the 10.00.0 definition files and creating 10.50.0 definition files and that isn't working. Copied and placed a 1050 folder in almost every sub-folder under Microsoft SQL Server both collectively and individually and tried all combinations. It works just fine when I'm connecting to a local instance but if I try a remote connection it never works, both locations with SQL 08 R2. I really don't want to have to install this on a VM, has anyone come across another work around for this?