Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Does a Stored Procedure locks...
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement