Re: [sqr-users] SQR locking table

[ashwin reddy <ashwin443@yahoo.co.uk>]

try putting a nolock in your sql and i hope it will work for  u .....
   
  SELECT * FROM tablename WITH (NOLOCK)

  
"Leonard, Kyle" <KyleLeonard@texashealth.org> wrote:
  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


       
---------------------------------
 Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for 
your freeaccount today.

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