02-10-2018, 01:08 PM
I think that is a known bug - but we didn't had any (other) SQL updates in the last year so this bug is still alive in older database versions
Please try the following command on your SQL database - it just add a "Order By " to the SQL command
ALTER PROCEDURE [dbo].[SecurityGroupGetAll]
AS
BEGIN
SELECT * FROM SecurityGroups Groups LEFT OUTER JOIN SecurityGroupUsers AssignedUsers ON (Groups.GroupId = AssignedUsers.GroupId) ORDER BY Groups.GroupId
END
GO
Please try the following command on your SQL database - it just add a "Order By " to the SQL command
ALTER PROCEDURE [dbo].[SecurityGroupGetAll]
AS
BEGIN
SELECT * FROM SecurityGroups Groups LEFT OUTER JOIN SecurityGroupUsers AssignedUsers ON (Groups.GroupId = AssignedUsers.GroupId) ORDER BY Groups.GroupId
END
GO
Regards/Gruss
Oliver
Oliver