title: SQL Server security, read-only default to new databases
body: <p>How do I set a Windows login on SQL Server so that it has read-only access to any database on the server, and will default to having read-only access to any subsequently added database.</p>
  
  <p>I would prefer T-SQL code.</p>
  
  <p>I am using SQL 2000</p>