Pinned topic Records affected limit
Below that value it shows correctly. Do you know anything about that limitation? I have opened a case and support claims that this is normal behaviour and to fix it we have to open an RFE. There is a limitation of no of packets analyzed for returned results.
We have tried to change the setting max_tds_response_packets to max level, but without any results.
Frankly speaking it is strange and we have security gap if someone in one query will have more than 120 th. records without any alert on sesitive data. This value seems to me low
KRZ 060000CA4Y87 Posts
Re: Records affected limit2013-04-03T16:27:01ZThis is the accepted answer. This is the accepted answer.Hi,
Did you restart the inspection engine? You need to do that before the change to take effect.
According to development, it's not a hard limit, and there are 3 related parameter which you can change using the store commands.
Hope this helps.
MARQ 270003JXPJ4 Posts
Re: Records affected limit2013-05-13T06:22:23ZThis is the accepted answer. This is the accepted answer.
- KRZ 060000CA4Y
In fact, these settings have limits and the problem is that MSSQL is not sending number of records affected like Oracle does and Guardium box has to count them. There is a limit and we have to monitor "-2" value as it indicates that the limit has been reached.