Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    6

    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?

    Gregg

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto
    Posts
    3

    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.

  3. #3
    Join Date
    Sep 2003
    Location
    Los Angeles
    Posts
    103
    The Database engine should be able to handle multiple calls.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •