title: Generating scripts for database role membership in SQL Server 2005
body: <p>I have a database with a lot of users in it. Those users belong to different built-in roles in the DB (eg db_ddladmin). </p>
  
  <p>I want to generate a script that creates those same users with the same role assignments to use in a different database. SQL Management Studio seems to only generate sp_addrolemember calls for user-defined roles, not the build-in ones. Is there any way to make it script all roles?</p>
  
  <p>Perhaps there is any other, better tool for generating database scripts from an existing database (preferably, but not necessarily, free)?</p>