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
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
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
3 matches
Mail list logo