Generate database script does not include database role members

I have read in the connect website (https://connect.microsoft.com/
SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125021)
That this issue was resolved in SP2. I have SP2 installed and still
have the same problem.
Am I missing something ?
-Noel
I looked under Tools | Options | Scripting and expected to see a new option
there, but did not find one. :-(
FWIW, I voted "5" on both 265852 and 125021.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
<isyourfriend@.gmail.com> wrote in message
news:1175102798.822976.257790@.n76g2000hsh.googlegr oups.com...
>I have read in the connect website (https://connect.microsoft.com/
> SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125021)
> That this issue was resolved in SP2. I have SP2 installed and still
> have the same problem.
> Am I missing something ?
> -Noel
>
|||(isyourfriend@.gmail.com) writes:
> I have read in the connect website (https://connect.microsoft.com/
> SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125021)
> That this issue was resolved in SP2. I have SP2 installed and still
> have the same problem.
> Am I missing something ?
I researched the issue and found that if you select "Script object permissions" it will script membership in user-defined roles, but not
in predefined roles like db_datawriter. I don't recall how SP1 worked;
maybe it did not script any membership at all. But in that case they
only fixed half the problem.
(And it's not intuitive that you need to select "Script object permissions".
I submitted
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=266078
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||On Mar 29, 6:18 pm, Erland Sommarskog <esq...@.sommarskog.se> wrote:
> (isyourfri...@.gmail.com) writes:
>
> I researched the issue and found that if you select "Script object permissions" it will script membership in user-defined roles, but not
> in predefined roles like db_datawriter. I don't recall how SP1 worked;
> maybe it did not script any membership at all. But in that case they
> only fixed half the problem.
> (And it's not intuitive that you need to select "Script object permissions".
> I submittedhttps://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?Fe...
> --
> Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
I am totally disappointed about the way M$ is handling BUGs that were
100% non existent on previous releases.
Thanks for the feedback.
-Noel