Recreate cursors when switching between default and scaleout scenarios

- Achieve this by recreating cursors that don't have the appropriate prefix
#2061