I am trying to run a simple query to report on all exe files on a bunch of PCs and the query doesnt resolve presumably because of the number of rows.
I am not great with sql and i am wondering if the limits are set there?
Can anyone tell me:
1) The default limit to a query - is it by no. of rows or size of query?
2) How/where to adjust these limits?
3) Is doing 2 a good idea!!? Is it possible to break anything?