ADO.NET Limit on Batch size

  • Thread starter Thread starter Venkatesh
  • Start date Start date
V

Venkatesh

Hi

Is there an ADO.NET limit on the amount of data that can
be impacted in a single batch ? I know that ADO had an 8K
limit

Thanks,

Venkatesh
 
What are you trying to do that exceeds this value (even if it's 8K)?

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
am concatenating several Stored procedure execute
commands in a string to be executed in a single batch. The
commandType is CommandText and the commandText is a string
such as:"Exec SP1 P1, P2;Exec SP2 P1P2..."
All this is executed in a single batch. I need to deal
with two limitations
1. Upper limit on batch size that ADO.NET can handle
2. Upper limit on Batch Size that SQL Server can handle
(65,536 * Network Packet Size)
 
Back
Top