[sqr-users] SQR locking table

["Leonard, Kyle" <KyleLeonard@texashealth.org>]

Using SQR 8.5 against a MS SQL Server 2000 database.

 

We have an SQR utility which uses a table to identify and run reports.
The SQR calls a stored procedure which updates or inserts into a table
to kick off other processes to run.  Recently we have noticed that the
table is locked until the SQR finishes processing keeping the other
processes from running.  

 

We've added Commits to both the SQR and the stored procedure without any
effect. Searching the archive has not lead to a solution.

 

Can anyone shed some light on what else might be occurring and how we
might be able to remove the lock immediately after the update/insert?

 

Thanks

 

_________________________________________ 

Kyle J. Leonard

Sr. Programmer Analyst

Financial Services

Texas Health Resources

 

 



The information contained in this message and any attachments is intended only 
for the use of the individual or entity to which it is addressed, and may 
contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from 
disclosure under applicable law.  If you are not the intended recipient, you 
are prohibited from copying, distributing, or using the information.  Please 
contact the sender immediately by return e-mail and delete the original message 
from your system.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users