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,longGroup,shortCompGroup,longCompGroup FROM user_cache WHERE entryId = '1000' _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
