Enable Pagination

[BenClark]

Hi all,

Using Enterprise 11.3, I've published a feature service that references data in a SQL Server 2017 DB but it doesn't support pagination. It's my understanding that anything past SQL Server 2012 should support this functionality by default. Is there anything specific I should be looking at to enable this? Images attached.

[BenClark]

Update: The service contained a tabular join to a view in another DB. After removing the join pagination became enabled. Is there any way to maintain such a join while keeping the pagination capability? Moving the view into the same DB as the feature class also breaks pagination.