set supportsLimitOffset to true

MS SQL has a work around for limit offsets