Add IntelliSense/AutoComplete Support for ALTER ROLE...ADD/DROP MEMBER Statement
I originally submitted this as a support case when I saw that there was no IntelliSense suggestions when writing an ALTER ROLE...ADD MEMBER or ALTER ROLE...DROP MEMBER statement (the former doesn't show potential users/groups for completion and the latter doesn't show current role members for completion), but after investigation on the Redgate side I was told this was a feature that was never implemented.
It would be great if we could get support added for this please, as ALTER ROLE is a core statement that has been around for many versions, and also because the alternative methods (e.g. spaddrolemember and spdroprolemember sprocs) are deprecated now and MS recommends the use of ALTER ROLE instead.
Thank you in advance for your consideration.
