Post reply

Deadlock

  • June 2, 2008 at 8:31 am

    #191837

    Hi ,

    I got Dead lock error message from error log file . its showing line number and object id .But that object having the inner procedures because of that can not able to find the exact line number . how can i find the exact line number ?

  • June 2, 2008 at 8:36 am

    #822968

    Which Trace flag did you use 1222 or 1204 ?


    * Noel

  • June 2, 2008 at 9:07 am

    #823001

    -T 2551

    -T 8003

  • June 2, 2008 at 9:24 am

    #823021

    Those trace flags are definitely undocumented and a google search reveal that they are used for capturing "sql dump info". You should use one of the ones I posted.


    * Noel

  • June 2, 2008 at 10:33 pm

    #823393

    thanks...will check and let you know ...

  • June 3, 2008 at 9:52 am

    #823734

    sudhakara (6/2/2008)

    Hi ,

    I got Dead lock error message from error log file . its showing line number and object id .But that object having the inner procedures because of that can not able to find the exact line number . how can i find the exact line number ?

    Here is the Bible on deadlock troubleshooting: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 6 posts - 1 through 5 (of 5 total)

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