Max Rows in SQL scan
I'm trying to configure SQL scans to limit the number of rows that are retrieved for each table. The online help and admin guide suggest that this is the correct syntax:
But I get failure to connect to "database_name,1000" as an error message. When I try without the the rows:
It works just fine, but it's taking forever since it's a large DB. That's why I was trying to limit the # of rows that are scanned for each table.
This is using DLP 11.6 against an MSSQL2008.
Is there something wrong with the synatx above?