title: Drop all logins where loginname like
body: <p>I'm looking to bulk remove users from a database with a script for every login with a name that matches a certain pattern.  What is the best way to do this with TSQL?</p>
  
  <p><code>DELETE syslogins WHERE....</code> does not work</p>
  
  <p>Trying to delete straight from syslogins will return "Ad hoc updates to system catalogs are not allowed"</p>