David Atkinson wrote:What would you say a sensible limit was? We'd rather avoid adding options if at all possible.
Red Gate Software
Actually 150 is probably a good choice for display. Could paging be implemented? Even a a message saying 150 of N displayed would be better because there is nothing in the application that tells you that there are more than what is being displayed.
In my case I was searching for references to a second database because there are those who want to move those functions into the current database. Most procedures and functions have references to this database so I wanted to get a number and generate a list. I can do it using T-SQL, but SQL Search could have been perfect, if it returned all the rows (at least a count) and if I had a way to export to csv or excel. So I'd suggest keeping the display limit to 150 and adding a total found count and a way to export all results.