title: Roles in SQL 2008 R2
body: <p>When I’m trying to create a role then I receive the error <em>“role exists”</em> and I have to deleted first and repeat the process.  </p>
  
  <ul>
  <li>How may I check if a role exists in my sql database in sql server 2008 r2?<br/></li>
  <li>Is there any <code>sys.table</code> to search for it?<br/></li>
  </ul>