Hi William, �SET QUALCOLS 10� is the statement, which lock a physical page, not a row. In fact, information travel forward and back by pages and it is possible the LAN HARDWARE to cause the problem if you have �SET QUALCOLS 2�! SET QUALCOLS 10 will slow down the database performance in multi-user mode about 3 times.
You should use explicit cursor � DECLARE CURSOR � for critical transactions for INSERT, UPDATE, and DELETE. Using an explicit cursor, you can trap errors, make transaction log file, log error file, and analyze problems. Move the crucial business logic and data validation into store procedures. That will execute them on the server. Konstantin _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
