Post reply

Trace a single session

  • September 8, 2009 at 11:02 am

    #134914

    Hi,

    This is a highly critical requirement and need to be done yesterday.

    I am in the process of reverse engineering the table data update from an application.

    I ran sql query analyzer and tracked all the sql's impacting the database.

    If i want to just get the sql run by only one session, how can i do that in sql server?

    In oracle, i can do it by dbms_system.set_sql_trace_in_session.

    I don't know what is the equivalent in sql server.

    If anyone know that, please explain with some examples.

    Thanks much.

    Murali

  • September 8, 2009 at 11:15 am

    #1050664

    Filter by the SPID of the connection you are looking for in the Profiler.

    Cheers,

    J-F

  • September 8, 2009 at 11:55 am

    #1050688

    Did that. Not seeing anything on the trace output.

    Guess it is waiting for data retrieval.

    Thanks

    Murali

  • September 8, 2009 at 12:01 pm

    #1050699

    Works beautifully.

    Thanks much.

    Murali

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

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