title: Strategies for distributing SQL-server-based application
body: <p>I have written an application in vb.net, based on SSCE.  Now I need to shift in SQL Server Express because I need to run the application on Sharing (LAN) and several users need to access the database at the same time.
  I am absolutely new to SQL Server.  I need to know the following:</p>
  
  <p>1) Do I create SQL Server DB by Adding New Item in my VS 2008? or they need to be created in SQL Server mgmt Express ONLY?</p>
  
  <p>2) How do I distribute these database, same way like SSCE databses?</p>
  
  <p>3) Can these databases be used like we use Access DBs in sharing (just put in the shared folder)?</p>
  
  <p>4) If no to Question 3, how to set the connection string as I donot know the name of computer of the user who will install my application.</p>
  
  <p>Thanks</p>