Post reply

Locking Statement

  • May 23, 2008 at 2:37 am

    #190980

    is there any way to find out the locking statement in particular stored procedure when lock happening ?

  • May 23, 2008 at 3:38 am

    #819555

    Hi,

    You can setup a trace to log the locking. Run this trace during the execution of the SP.

    You might want to ensure you are the only user, to prevent too many things to be logged by the trace 😉

    Regards,

    Hans

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • May 23, 2008 at 6:56 am

    #819627

    sp_lock session id will the table name with status as wait . instead of table name ,i want find out the statement or line no of stored procedures

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

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