Unable to Replay Default Profiler Trace

  • Hello Everyone,

    I am facing an issue wherein the default trace file(.trc) when opened with profiler on the same server doesn't allow to replay and I get the error as below.

    I tried to find oout on google if this is a problem and what would be a resolution but to no avail.

    Cans omeone please share if there is something that I am doing wrong or if this is a default behaviour ? My server is Sql Server 2008 R2

  • The default trace template "Standard (default)" cannot be used to replay the actions. You should create a new trace and select the "TSQL_Replay" trace template.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • Thanks for confirming that its the default behaviour 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply