Hi,
Please could somebody advise on the following.
If a stored procedure is executed via C# and is contained within a Try Catch does this grant any exclusive locks on tables within the stored procedure or wrap the stored procedure with a begin transaction for example?
We have an issue whereby a service is timing out when updating a table that is contained within the stored procedure being executed via C#. The stored procedure being executed takes 30-40 minutes to complete (I know it takes a long time, I didn't code it, honest! 😛 )
Sorry if there isn't enough info, please let me know if I should include more.
Regards,
Adam