Try putting this at the stop of the stored procedure:
SET XACT_ABORT ON
Roman
>Dear all,
>
>I wrote an ASP program to do a batch update for SQL Database. As before, I'm using COM object to do but it always cause an error "Transaction context is in use by another session". I searched MSKB to locate the document which notify that is a bug of SQL Server but it didn't have any fix for it. Coming later, somebody tech me to change the COM object to Stored Procedure. At the beginning, everything is ok and the problem is solved. But after I implement the program to Live Environment, the problem comes again. Anyone can help me to solve the problem?
>
>Basically, I just use the stored procedure to retrieve, insert and update the records. ASP contains all business rules. It's get me crazy and Thank you for your help .....
>
>Best Regards,
>
>Ty Ty
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729