Hello,
I observe a row limit in the query, when performs a query to the agent database MSSQL it returns a max 1000 rows, but should be much more.
Is there any way to disable or set another limit?
And is it safe.
When I manually add the limit for example adding “LIMIT 1100;” on the end of query, it returns 1100 rows.
Hi,
Are you talking about executing queries in the ‘query executor’ window of the System Center tools section?
There is indeed a safety mechanism which will add LIMIT 1000 to the query, if no limit was defined. AFAIK there is no way to disable or change this. The only thing you can do, is add a higher limit yourself in the query. If you specified a higher limit yourself, you override the default one of 1000, but you cannot change that 1000.
Bert
Hi,
Yes I talking about it. Thank you for your answer.