title: How do I open a SQL Server database read-only?
body: <p>I have a windows service writing to a single-table SQL Server database (2008).</p>
  
  <p>I want another application to read the table in read-only mode.</p>
  
  <p>What do I have to do to open the database appropriately by the application so it's read-only?</p>
  
  <p>Any changes to the way the service opens the database?</p>
  
  <p>Obviously I can't ALTER the database to read-only as the service has to write to it.</p>