Re: Stored Procedures

>When you are executing a store procedure from a trigger how long does the >row that triggered the procedure stay locked? Until completion? I'm having >problems with row locking and its caused by the stored procedures that are >updating other tables. > > > > > The stored procedure and the row that triggered the stored procedure are part of the same transaction. Update locks for both will be freed at the same time. Madison Pruet