title: set sql server connection to readonly?
body: <p>How do I set a SQL server connection to readonly? I tried Googling and all I found was <code>File Mode=Read Only</code>, but it didn't work (File Mode keyword not supported). The reference looked SQL CE specific.</p>
  
  <p>No luck with SQLite <code>Read Only=True</code> either.</p>
  
  <p>-edit-</p>
  
  <p>My connection string is below. I have no clue when it comes to configuring the tables. I don't know how to make users/permissions.</p>
  
  <pre><code>rdconn = new SqlConnection(@"(wrong)Read Only=True;Server=.\SQLExpress;AttachDbFilename=test2.mdf;Database=dbo;Integrated Security=SSPI;User Instance=True;");
  </code></pre>