SQL Server stored procedure in multi threaded environments
- by Shamika
Hi,
I need to execute some Sql server stored procs in a thread safe manner. At the moment I'm using software locks (C# locks) to achieve this but wonder what kind of features provided by the Sql server itself to achieve thread safety. It seems to be there are some table and row locking features built in to Sql server.
Also from a performance perspective what is best approach? Software locks? Or Sql Server built in locks?
Thanks,
Shamika