I have two quick questions:
1. Is it possible to return more than the max of 512 rows for either the query or select operators?
2. Is it possible to pass Windows Credentials as login to the Database Server?
The 512 Row limit is hard coded and cannot be altered.
You can send Windows Credentials to the database. Please see the "Enable Windows Integrated Security for the JDBC Module for MSSQL Server" section in the Content Administrator Guide for details.
Retrieving data ...