var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Web Server to SQL Server Question
I have a SP that is called everytime that a user enters a transaction in the web page the has a Begin Trans and Commit in it.
My question is can multiple poeple enter transactions using the same SP at the same time?
RE: Can SP be accessed by multiuser?
Of course. Database is multithreaded. Stored Procedures, Functions, Tables, Views, etc. all can be accessed by different user at the same time.
The Database engine should be able to handle multiple calls.
Yes - Do you have any concerns/issues ?
If you do not have SQL Server Books Online (BOL) installed - please do so. The majority of questions asked in the SQL Server forum could be eliminated if people had access to bol. BOL