USP_ROLESYNC_GETROLELIST

Gets a list System Roles to be processed by the RoleSync utility.

Definition

Copy


            create procedure dbo.USP_ROLESYNC_GETROLELIST
            as
            --Used by the RoleSync utility

            set nocount on;

            select SR.ID
            from dbo.SYSTEMROLE AS SR


            ORDER BY SR.NAME ASC