[RANGER-2920] Improvement in DB scripts for handling upgrade scenario for MS-SQL

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Component/s: Ranger
• Assignee: Dhaval Shah
• Reporter: Dhaval Shah
• Created: 21/Jul/20 09:45
• Updated: 21/Jul/20 11:53
• Resolved: 21/Jul/20 11:53

Description

1.) 046-insert-statename-in-x-ranger-global-state.sql
Need to change getXportalUIdByLoginId to dbo.getXportalUIdByLoginId

2.) 047-sortorder-column-size.sql
=> Declare scalar variable stmt

Issue Links

• relates to: RANGER-2914 Invalid obj name in DB script for MS-SQL
• links to: Review Request