+ Reply to Thread
Results 1 to 2 of 2

Deadlock isn't logging SQL statements

  1. Deadlock isn't logging SQL statements

    Hi,
    I'm running SQL 2005 SP1 and we're getting some deadlocks. There is nothing
    written to the event log. I've turned on 1204 and the log is showing the
    deadlock however again, no SQL statements. I see this in the SQL Server log:
    Log Viewer could not read information for this log entry. Cause: Data is
    Null. This method or property cannot be called on Null values.. Content:.

    I've also tried profiling deadlock and deadlock chain events and I can't get
    the SQL still. Anyone tell me what I'm doing wrong?

    Thanks

  2. Re: Deadlock isn't logging SQL statements

    Hi
    http://blogs.msdn.com/bartd/archive/...09/747119.aspx
    http://blogs.msdn.com/bartd/archive/...25/770928.aspx




    "sqlboy2000" wrote in message
    news:03FDEDA3-935F-458F-81AA-9489BAB1C2B5@microsoft.com...
    > Hi,
    > I'm running SQL 2005 SP1 and we're getting some deadlocks. There is
    > nothing
    > written to the event log. I've turned on 1204 and the log is showing the
    > deadlock however again, no SQL statements. I see this in the SQL Server
    > log:
    > Log Viewer could not read information for this log entry. Cause: Data is
    > Null. This method or property cannot be called on Null values.. Content:.
    >
    > I've also tried profiling deadlock and deadlock chain events and I can't
    > get
    > the SQL still. Anyone tell me what I'm doing wrong?
    >
    > Thanks




+ Reply to Thread