sp_trace_create to replace profiler in 2005 express?

  • Since we can't use profiler on express, is it possible to start a server-side trace and read the trace file into a table for further analysis?

  • didn't i already answer this for you :unsure: .

    The SP's and Functions are there so no reason why you couldn't perform a server side trace.

    Check the following link for details on how to set this up

    http://www.sqlservercentral.com/Forums/Topic576752-146-1.aspx

    and yes you can dump the trace to a table 😎

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Thanx for the answer... afaik it was the first time I asked for this :).

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

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