Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dan Guzman Stairway to Server-side Tracing - Step 2: Creating a SQL Trace Using T-SQL (Stairway Series) RE: Stairway to Server-side Tracing - Step 2: Creating a SQL Trace Using T-SQL (Stairway Series)

  • April 22, 2011 at 10:43 am

    #1314945

    Grubb (4/8/2011)

    Guys, after I create, run, stop, and delete the trace, I cannot ever seem to open the resulting file with Profiler: "Access denied". I'm assuming something still has it locked.

    I am able to view it using fn_trace_gettable().

    Am I missing a step?

    Nevermind...It was truly a permissions issue. It's fun being a DBA without local admin access 🙁