Hi,

We have a lot of triggers that invoke stored procedures (wich inside has a lot of SELECT statements), and we have some problems of performance. Since we can use (NOLOCK) on SELECT statements to improve performance (although we can loose data consistency), my question is:

Does calling a Stored Procedure LOCKS (besides having SELECT statements inside with NOLOCK)?


Thanks in advance.


Ricardo Almeida