Database query browser

Is there a setting you can change to get more than 1000 rows to show up in the database query browser that you can use in the ignition designer?

Yeah, just add a limit to the query in the designer.
MySQL:SELECT * FROM history limit 2000
MSSQL:SELECT TOP 2000 * FROM history

So there is no setting you can change to show more rows automatically when you open the browser???

No, it is built-in to the query browser.