title: Multiple connections to one sql database
body: <p>I have a small problem and I was hoping some of you guys have any experience with that.
  First of all I'm gonna explain what am I planning to acomplish.</p>
  
  <p>I'm building a program for windows server working with local SQL Server DB (SQLEXPRESS 2008). I think it doesn't matter in my question, but it's gonna be written in C#.</p>
  
  <p>This program is using this DB as a shared data holder between all of the win server users. That means one process for one user and that means one connection to SQL and DB for one user at the time.</p>
  
  <p>And my question is. Imagine situation that one user is inserting something into this DB and exactly at the same time some other user wants to connect to this DB and read something. Is it gonna throw exception? Is it gonna wait on a queue? I really don't know and it's kind of hard to test this situation.</p>
  
  <p>So If anybody has any idea, I would really appreciate it. Looked deep into google but couldn't find the answer for this.</p>
  
  <p>Thanks in advance.</p>