User Profile

Collapse

Profile Sidebar

Collapse
gjspaho
gjspaho
Last Activity: Jul 5 '07, 09:27 AM
Joined: Mar 26 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gjspaho
    replied to urgent deadlock problem on Sql Server 2000
    in SQL Server
    i modified the select sp in the from clause(deadlock object table) with "with (nolock)"
    and no deadlock happend since
    hope this works
    thank you for your response
    See more | Go to post

      Leave a comment:

    • gjspaho
      started a topic urgent deadlock problem on Sql Server 2000
      in SQL Server

      urgent deadlock problem on Sql Server 2000

      it occours every about 5-6 minutes
      this is the info i fo8und on sql server log

      2007-03-26 12:55:33.64 spid4 ResType:LockOwn er Stype:'OR' Mode: S SPID:135 ECID:0 Ec:(0x4DB77570) Value:0x4a
      2007-03-26 12:55:33.64 spid4 Victim Resource Owner:
      2007-03-26 12:55:33.64 spid4 ResType:LockOwn er Stype:'OR' Mode: X SPID:137 ECID:0 Ec:(0x4DE61570) Value:0x4a
      2007-03-26 12:55:33.64 spid4 Requested By:
      2007-03-26...
      See more | Go to post
      No activity results to display
      Show More
      Working...