SQL Fixes

[zweistift]

Hello

Is it planned to fix the following SQL "issues" in the next version?

[We use ASG 11.0.5988.1 in combination with SQL Server 2016 SP1
We've used the Microsoft Data Migration Assistent to create an assessment.]

issues:

tables:
ItemProperties --> column Data is ntext => change to nvarchar(max)
Items --> column Description is ntext => change to nvarchar(max)
Logs --> column Details is ntext => change to nvarchar(max)

procedures:
"Old WHERE syntax"

Code:

ALTER PROCEDURE [dbo].[SecurityGroupAssignmentsForAllItemsGet] AS
SELECT * FROM SecurityAssignment Assignments, SecurityGroups Groups
WHERE
Assignments.GroupId = Groups.GroupId
ORDER BY
ItemId, Groups.GroupId

--to:

ALTER PROCEDURE [dbo].[SecurityGroupAssignmentsForAllItemsGet] AS
SELECT * FROM SecurityAssignment Assignments
LEFT JOIN SecurityGroups Groups
ON Assignments.GroupId = Groups.GroupId
ORDER BY
Assignments.ItemId, Groups.GroupId

Best regards,

Simon