Re: Sql process and hanging ARServer

2006-09-17 Thread Piotr Polewczak
the blocking process is : sp_cursorclose;1 the directly blocked querys : SELECT COUNT(*) FROM (SELECT distinct userName, password, authString FROM servgrp_userlic WHERE groupId = -1) as d1 SELECT MAX(timestamp) FROM user_cache SELECT userName,password,authString,fixedLicChange,shortGroup,longGr

Re: Sql process and hanging ARServer

2006-09-15 Thread Axton
Post the sql statemenst for the first two threads that enter the deadlock. Read up: http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm http://support.microsoft.com/?kbid=832524 Axton Grams On 9/15/06, Piotr Polewczak <[EMAIL PROTECTED]> wrote: Hi, i've got problem with hanging arserver, pro

Sql process and hanging ARServer

2006-09-15 Thread Piotr Polewczak
Hi, i've got problem with hanging arserver, problem appears when one sql process (connection from arserver) starts to lock other processes. Command in blocking process is : sp_cursorclose;1 Resources locked by process are : ARSystem.dbo.servgrp_userlic, ARSystem.dbo.user_cache, ARSystem.dbo.T10