SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in [13.0.52 Beta] - Not showing built-in roles      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic [13.0.52 Beta] - Not showing built-in roles Author Message gemisigo Joined: 11 Mar 2010 Posts: 2137 [13.0.52 Beta] - Not showing built-in roles I've had this issue in v12 too. SA no longer seems to include built-in roles in the popup for statements like ALTER ROLE in SQL Server. It only shows user-created roles. Is there a setting that controls this behavior? Mon Jul 08, 2024 6:19 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7903 Built-in roles get filtered out at a lower level as they are typically not expected to be touched or needed in Intellisense prompts. If you would like to change that behavior, you can modify Options -> DB Options - >SQL Server -> Database Objects query-> in the code of subquery for principals comment out "is_fixed_role = 0" Mon Jul 08, 2024 8:03 am gemisigo Joined: 11 Mar 2010 Posts: 2137 Thanks, that "fixed" it :) Mon Jul 08, 2024 8:33 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.