Have created an ADP linking to our Reference Data on an instance of SQL. One of the users has just pointed out a problem with (SQL Server) tables that contain many rows i.e. in the ADP only 10000 are shown (as if it is a default number). I have spent hours looking for somewhere that this might be set and going thru the help, msdn and technet but cannot find anything.
Would appreciate being pointed in the right direction.
Thanks