Why doesn’t SQL Server automatically check for the Group –> Object type when you are adding perms via SSMS? This hangs me up almost every time. I think “omg where is the group, why isn’t it there?” and then I remember, oh yeah, I gotta check that box. It seems like it should be checked by default. Does anyone else know why Groups isn’t checked by default?
Anyway, reminder to myself, make sure the Groups object type is selected when adding a group through the GUI.