Subject Problem with a stored procedure
Author Marco Aurélio Castro

My system has a stores procedure that calculates the balance of and account. This SP takes from the first to the last record recalculating the record. If another station tries to write in this table while the SP is being processed the system craches. Only doing the backup and restoring the database I'll be able to access the table again.

Any sugestuin? How could I lock the table during the SP? Is it the better way?


Marco Castro

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.501 / Virus Database: 299 - Release Date: 14/7/2003

[Non-text portions of this message have been removed]