Proc with MTS causes EM to lock up when Foriegn key violation 
Author Message
 Proc with MTS causes EM to lock up when Foriegn key violation

This simple proc runs fine if no foriegn key violations occur or without MTS
transactions
However, as is it Locks up my Enterprise Manager when an error is thown.

Any Ideas

Earl

Create PROCEDURE uspUpdateUserRolesWithMts


As

BEGIN TRANSACTION UpdateUserRoles

    --Delete Current Roles From User



 BEGIN


      BEGIN


      END
  ELSE
      BEGIN


      END



 END


 BEGIN
     RAISERROR ('Update to user roles failed', 16, 1)
     ROLLBACK TRANSACTION UpdateUserRoles
     RETURN 99
 END

 COMMIT TRANSACTION UpdateUserRoles



Wed, 29 Jun 2005 14:10:37 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Stored proc causes access violation

2. SQL6.0 - Stored proc causing access violation

3. Indentity field causing primary key violation

4. UPDATE causing Key Violation

5. Paradox Autoincrement Fields Cause Key Violation -- Help!

6. PDOXWIN 5.0: Lock up with key violation

7. foreign key causing unwanted record lock

8. SQL Server Foriegn Key Problem

9. partitioned view foriegn key

10. Newbie question - foriegn key and cascading updates

11. Newbie Question -- Verify foriegn key inserts

12. please help on foriegn Key


 
Powered by phpBB® Forum Software