title: Need to use the database name while creating a role
body: <p>I need to create 2 database roles (need to write the script for this task) <code>databasename_dbo_reader</code> and <code>databasename_dbo_writer</code> for all the databases on a server.</p>
  
  <p>I have tried the following:</p>
  
  <pre><code>Declare @databasename sysname
  SELECT @databasename = (SELECT DB_NAME())
  exec ('CREATE ROLE' + @databasename + '_DBO_WRITER')
  </code></pre>
  
  <p>but it is throwing some syntax errors. Please help.</p>