Move sp_addrolemember scripts to be in User Object instead of Roles Object
In our System we have 2-3 predefined Roles that the application uses to run against.
The Issue I am running into is when scripting the roles i don't want all the sp_addrolemember being scripted into source control as the users using the role will be different in different environments. So it will always show up as a diff if the Role is already created and assigned to a user.
I would like suggest adding those sp_addroletomember scripts be configurable to be scripted in the User object they belong to instead of in the Role Object